Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Create and Insert Command Example
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE Customer ( CustID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); Insert into Customer Values (1,'Sanford','Dave','4000 Whiting Dr.', 'MI'); SELECT * FROM Customer;
run
|
edit
|
history
|
help
0
Delete double entries from a table without primary key
UNPIVOT
updated
1D Hotel
Numbers
Merge statement
Trabalho.Agrecação
new
Libros
Pivot unpivot