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)
 Auto Insert Data

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-08 : 10:12:20
Joseph writes "How do I automaticly insert data into columns depending on certain entries from certain rows. Each row will have different data for those particular rows.
Basicly I want to set it up, so if the users decided not to fill out certain columns, I can do it in one sweep by looking at empty columns."

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-08 : 11:29:13
Consider default values for columns, or if you have logic which needs to be evaluated to determine the value(s) you want, consider an insert trigger.

Go to Top of Page
   

- Advertisement -