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.
| Author |
Topic |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2008-08-07 : 03:20:36
|
| HiMy aspx form has 100 fields to be inserted from a webservice to sql database table having 100 columnsIts not feasible to write such a big insert query in webservice. whats the other alternative?(I can not divide the table into multiple table) |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-08-07 : 10:25:00
|
| Use a stored procedure and call the proc from your web service.Stored procs are recommended practice anyway.--Gail ShawSQL Server MVP |
 |
|
|
jhermiz
3564 Posts |
Posted - 2008-08-11 : 11:07:19
|
quote:
Originally posted by GilaMonster
Use a stored procedure and call the proc from your web service.Stored procs are recommended practice anyway.--Gail ShawSQL Server MVP
I feel bad for the end user whose got to fill in those 100 required fields?Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
|
|
|
Inserting 100 fields to table with 100 columns