Advertisement
Guest User

Untitled

a guest
Jul 15th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. select * into dbo.tmp from dbo.something
  2. go
  3.  
  4. declare @thedate as varchar(100)
  5. set @thedate = 'something'+convert(nvarchar(MAX), getdate(), 13)
  6.  
  7. EXEC sp_rename 'tmp', @thedate
  8. go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement