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)  Which is which?

Author  Topic  gds Starting Member 29 Posts Posted - 2001-04-09 : 23:25:10 GOOD DAY TO ALL SQL-SERVER DEVELOPERS Scenario: I'm planning to execute an INSERT STATEMent in a header -> detail table. I'm using Visual Basic as my front-end and SQL 2000 as my back-end. The number of fields in the header table is 20 and detail table is 50. Number of rows to be inserted in the header table 4000 and detail is 10000. Which is faster and efficient in terms of performance and execution. a.) Binding the recordset in the Data-Source or use Direct-SQL b.) Use disconnected recordset and loop the recordset and perform a direct-SQL by using the connection object. c.) Create a stored procedure and defined all the fields as parameters and call the stored procedure d.) Or you have another idea or solution of my problem. P.S. Please HELP