TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Morcos Adel
NA
195
50.4k
Bulk update with a stored procedure ?
Aug 17 2011 7:38 AM
Hi...
actually i am working on a performance issue,i have a 1000 record in a gridview in a web page and i am allowing the editing of the data and when a save button is clicked i want to update the records in the database again using a stored procedure is there another way to update my database without fetching each row of the gridview in the update process??
i mean can i just pass a datatable or something to the sqlserver in the stored procedure parameters and then it updates it self ????
thanks in advance
Reply
Answers (
4
)
Error occour while attaching .mdf file in sql server
T-sql execute faster