select Archives - anydragon

MSSQL Table List Query

(10%) select name from sysobjects where type=’U’ (13%) select * from information_schema.tables (76%) select * from sys.tables

Select Insert

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

1

2

3

4

INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...

FROM table1

WHERE condition;