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
 sql insert

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-24 : 07:44:23
jagadish writes "I have 25 textboxes,dropdownlist aand datetime and what to insert them in the database in single time. depending on the resoures.
for example once i want to insert 20 records adn some time 10 records and 25 some time.
How to write the inser statment for this . please help"

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-05-24 : 07:53:49
CHeck out this function
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685&SearchTerms=Numbers,table

And Then
Insert TAbleName
Select <Your Values i.e textboxes, datetimes> From bo.F_TABLE_NUMBER_RANGE(1,20)

This will insert 20 records in one startch..

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page
   

- Advertisement -