Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Create MS SQL Server CUSTOMERS Table
--Sql Server 2014 Express Edition --Batches are separated by 'go' CREATE TABLE CUSTOMERS( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , SALARY DECIMAL (18, 2), PRIMARY KEY (ID) );
run
|
edit
|
history
|
help
0
Test if a string can be made with substrings!
book
Find the database which have specify table name
new
Madelin
customers table
MyDb
sql 7
First Query
Window Functions - ROW_NUMBER()