Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * into dbo.tmp from dbo.something
- go
- declare @thedate as varchar(100)
- set @thedate = 'something'+convert(nvarchar(MAX), getdate(), 13)
- EXEC sp_rename 'tmp', @thedate
- go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement