WorkaHolic/MSSQL
MSSQL INSERT TABLE SELECT TABLE
쫌
2010. 12. 7. 15:48
반응형
1. DB Link
- SELECT * FROM [LinkDB].[DBO].[SelectTable];
2. Insert Into Select Table
- INSERT INTO [InsertTable] SELECT * FROM [LinkDB].[DBO].[SelectTable];
- SELECT * FROM [LinkDB].[DBO].[SelectTable];
2. Insert Into Select Table
- INSERT INTO [InsertTable] SELECT * FROM [LinkDB].[DBO].[SelectTable];
반응형