Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select description from codes
- DECLARE @OPENQUERY NVARCHAR(4000) ,
- @TSQL NVARCHAR(4000) ,
- @LinkedServer NVARCHAR(4000);
- SET @LinkedServer = 'lnk_test';
- SET @OPENQUERY = 'SELECT * FROM OPENQUERY(' + @LinkedServer + ',''';
- IF OBJECT_ID('codes', 'U') IS NOT NULL
- BEGIN
- DROP TABLE codes;
- END;
- CREATE TABLE codes
- (
- code_id INT ,
- comment TEXT
- );
- PRINT 'Getting stuff';
- SET @TSQL = '
- select code_id, description from codes
- '')';
- PRINT @OPENQUERY + @TSQL;
- INSERT INTO codes
- EXEC ( @OPENQUERY + @TSQL
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement