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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 i have a question,please help me!

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-29 : 07:32:56
Ponty writes "i want to create a table(dynamic stored prosedure) that when user enter a number of rows and columns,it automatically crate a table with those rows and column.
for example when user enter a 3 and 4,it create a table with 3 columns and 4 rows.
sorry for my bad spelling because i cant speak english...
our faculty said to us that if we have a good skills in searching,we can find the answer in this site and msdn.com,but i cant find that...
please help me"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-29 : 07:39:14
This type of table creation is not recommended at all
You need Dynamic SQL
Refer here
http://www.sommarskog.se/dynamic_sql.html

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -