Advertisement
Guest User

Untitled

a guest
Jul 1st, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. select description from codes
  2.  
  3. DECLARE @OPENQUERY NVARCHAR(4000) ,
  4. @TSQL NVARCHAR(4000) ,
  5. @LinkedServer NVARCHAR(4000);
  6.  
  7.  
  8. SET @LinkedServer = 'lnk_test';
  9. SET @OPENQUERY = 'SELECT * FROM OPENQUERY(' + @LinkedServer + ',''';
  10. IF OBJECT_ID('codes', 'U') IS NOT NULL
  11. BEGIN
  12. DROP TABLE codes;
  13. END;
  14. CREATE TABLE codes
  15. (
  16. code_id INT ,
  17. comment TEXT
  18. );
  19.  
  20. PRINT 'Getting stuff';
  21.  
  22. SET @TSQL = '
  23. select code_id, description from codes
  24. '')';
  25.  
  26. PRINT @OPENQUERY + @TSQL;
  27.  
  28. INSERT INTO codes
  29. EXEC ( @OPENQUERY + @TSQL
  30. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement