Guest User

Untitled

a guest
Jun 18th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. CREATE TABLE text_test (test NTEXT NOT NULL)
  2.  
  3. INSERT
  4. INTO text_test
  5. VALUES ('test')
  6.  
  7. DECLARE @t NVARCHAR(MAX);
  8.  
  9. DECLARE txt_cur CURSOR FOR
  10. SELECT test
  11. FROM text_test
  12.  
  13. OPEN txt_cur
  14.  
  15. FETCH NEXT
  16. FROM txt_cur
  17. INTO @t
  18.  
  19. CLOSE txt_cur
  20.  
  21. DEALLOCATE txt_cur
  22. GO
  23.  
  24. DROP TABLE text_test
  25. GO
Add Comment
Please, Sign In to add comment