Sql

SET IDENTITY_INSERT TABLE_TO ON
INSERT INTO TABLE_TO (Col1, Col2, Col3, ...ColN) SELECT * FROM TABLE_FROM
SET IDENTITY_INSERT TABLE_TO OFF

INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]   
VALUES (value1, value2, value3,...valueN);

PREVIOUS	NEXT

Code Example
Sql :: sql order by case
Sql :: sql decimal to 2 places
Sql :: t sql to rebuild all indexes in a database
Sql :: select latest entry in sql table
Sql :: sql in sublime
Sql :: oracle list duplicates
Sql :: mysql how to change default charset
Sql :: sql where contains
Sql :: allsource oracle
Sql :: mysql sort descending
Sql :: can you update NULL in sql
Sql :: sql calculate percentage
Sql :: mysql order
Sql :: mysql add root password
Sql :: sql string data type
Sql :: Add SuperUser MySQL
Sql :: postgresql cast
Sql :: change date format in oracle query
Sql :: sql date get month
Sql :: mamp mysql path mac
Sql :: SQL Auto Increment Primary Key - SQL Server
Sql :: how to truncate all table in mysql workbench
Sql :: min salary in sql
Sql :: select if then postgresql
Sql :: plsql print
Sql :: recently updated stored procedure in sql server
Sql :: drop multiple columns in sql
Sql :: oracle sql pad left zeros
Sql :: mysql query dates between two dates
Sql :: events mysql