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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Need Help to understand the DB better

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-06 : 08:47:07
ghouse writes "1. My Application need to add a column to the existing table from the frontend Which is "Asp.net" for my application, here i trying to pass both ColumnName and th Datatype through Frontend as Parameter to the SQL SERVER StoreProcedure.
2.Similarly i want to Create the table dynamically Through the frontend"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-06 : 08:50:02
Why are you creating tables and columns dynamically from your application??? This is usually a sign of really, really bad design. If you do decide to code this way anyway, you just need to use the ALTER and CREATE statements. If you don't even know that much about SQL Server though, you need to buy a book. There are also plenty of good examples at www.asp.net.

Start studying.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -