Common SQL Server syntax at work

I have been engaged in Oracle development before and found that some SQL server operations are still different from those of Oracle.

Create a table based on an existing table:

Oraclec creation method:

Create Table temp_org_employee
Select * From org_employee

SQL Server creation method:

Select * into temp_org_employee from org_employee

 

Modify the column type and length

Create Table Name (column A varchar (10); goalter table name alter column A nvarchar (25) not null; // not empty goalter table name alter column A varchar (50) NULL; go

 

Add or delete a column

Create Table Name (column A varchar (10); goalter table name Add column Column B nvarchar (25) NULL; // Add a field goalter Table Name drop column Column B varchar (50) NULL; // delete a column go