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)
 use triggers to create tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-08 : 07:57:51
aditya writes "hi,

i have a table called DETAILS with NAME as one of the fields
i want to create a table with the value in the NAME column when i enter the value and move to next row

can i do this with triggers
if so how
or else
what are the other methods to do this

thank you"

Andraax
Aged Yak Warrior

790 Posts

Posted - 2005-02-08 : 09:43:40
Hello!

It's possible to do with a trigger, but it's probably not a good idea. Why do you want to create new tables based on what you insert into a table? You can probably solve it in a much better way with a fixed database design.

/Andraax
Go to Top of Page
   

- Advertisement -