Viewing 15 posts - 481 through 495 (of 1,048 total)
Hugo Kornelis (5/27/2013)
Mighty (5/27/2013)
One remark though:
...if you run code that generates an actual error
This not only works when an error has been generated. Any...
May 27, 2013 at 3:44 am
Lokesh Vij (5/15/2013)
I found Today's question relatively easier than yesterday. 🙂
true 😛
May 15, 2013 at 1:06 am
Good question Hugo..
Specially the link of CASE won't always evaluate in order 🙂
May 15, 2013 at 1:06 am
I solved it...
suggesting solution if someone else faced this issue:
Go the SQL server confiuration manager > select Ib built accounts > Local System
It works like a charm 🙂 :-):-D
May 11, 2013 at 2:20 am
But how can we stop the trigger from being runned when updation is performing on some another column of a table
May 10, 2013 at 6:55 pm
Danny Ocean (5/10/2013)
Good question, but Explanation is not completed or require more details.I think hugo can help us.
Right Vinay 😛
May 10, 2013 at 1:08 am
Mark-101232 (5/9/2013)
WITH CTE AS (
SELECT ID,VoucherNo,Status,VoucherType,
ROW_NUMBER() OVER(ORDER BY ID) AS rn1,
ROW_NUMBER() OVER(PARTITION BY Status ORDER BY...
May 9, 2013 at 4:26 am
nenad-zivkovic (5/9/2013)
Toreador (5/9/2013)
If a column is referenced in a subquery that does not exist in the table referenced by the...
May 9, 2013 at 3:18 am
IgorMi (5/9/2013)
What does its execution plan say? Are there any missing indexes? How big are the tables? Check the statistics on them.
You can replace the IN with EXISTS and NOT...
May 9, 2013 at 1:29 am
Try this--
ALTER DATABASE [DATABASE_NAME]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
DROP LOGIN [Test2]
May 9, 2013 at 12:29 am
Viewing 15 posts - 481 through 495 (of 1,048 total)