question

sandeep_121 avatar image
sandeep_121 asked

create a table theough sp

i want create a table just like this-: declare @datetime datetime declare @date varchar(20) select @datetime=(GETDATE()-1) select @date=convert(varchar(10),@datetime,112) print @datetime print @date create table #businessmster+'_'+@date ( contentid int ) tbale name=#businessmaster+'_'+@date"
sql-server-2008sql-server-2005sql-server-2012sql-server-2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sajikumar.vk avatar image
sajikumar.vk answered
create proc CreateTable as begin declare @datetime datetime declare @date varchar(20) declare @Table_Creation_Query varchar(5000) declare @TableName varchar(200) select @datetime=(GETDATE()-1) select @date=convert(varchar(10),@datetime,112) print @datetime print @date select @TableName = '##businessmster' + '_' + @date select @Table_Creation_Query = 'create table ' + @TableName + ' (contentid int )' exec (@Table_Creation_Query) end
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.