Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pavank
Starting Member
4 Posts |
 Posted - 2002-10-27 : 09:05:53
|
| Hi, I need help to create a table using stored proceedure where in i will pass table name as parameter. Stored proceedure must take the parameter of table name and create table. |
|
|
rharmon
Starting Member
41 Posts |
Posted - 2002-10-27 : 11:46:44
|
| Untested, but I'm sure you'll get the idea:create procedure maketable(@t_name varchar(50))asdelclare @sqlstring varchar(4000)set @sqlstring = 'create table ' + @tname + '(somefield int)'execute (@sqlstring) |
 |
|
|
pavank
Starting Member
4 Posts |
Posted - 2002-10-28 : 09:13:00
|
| Hi rharmon, Thanks for taking time to solve my query and its working :-) Pavan |
|
|
|
|
|
|
Stored proceddure to create a table