Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Database Query

Posted on 2011-09-05
3
Medium Priority
?
248 Views
Last Modified: 2012-05-12
If there is failure during updation of certain rows, what will be the state?
0
Comment
Question by:KaranGupta
  • 2
3 Comments
 
LVL 17

Expert Comment

by:OmniUnlimited
ID: 36486458
0
 

Author Comment

by:KaranGupta
ID: 36486473
Hi OmniUnlimited

I think there is some confusion. I am not looking for the error handling techniques. I want to know what will be the state.


Regards
Karan
0
 
LVL 17

Accepted Solution

by:
OmniUnlimited earned 2000 total points
ID: 36486481
Error state level on an invalid update query is 16.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question