Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.27 KB | None | 0 0
  1. SELECT COLUMN_NAME FROM temp.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '' + @dstname + '_TMP' AND COLUMN_NAME like '%_ID'
  2.                 open @cursor2
  3.                 fetch next from @cursor2 into @col
  4.                 while @@FETCH_STATUS = 0
  5.                 begin
  6.                     set @sub = substring(@col, 1, (len(@col)-3))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement