Viewing 15 posts - 1,006 through 1,020 (of 1,048 total)
Vey nice question....
but my response was wrong 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 9, 2012 at 3:22 am
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 9, 2012 at 1:42 am
nice question..
learn something new today!!:-)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 9, 2012 at 1:40 am
why query for step 2 result only 5 rows--
What will the original SELECT * FROM VOrder_Details (Step 2 above) statement return when executed?
As, I think that when we made...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 9, 2012 at 1:25 am
Hi,
sorry I forget about passing parameters..
chk this one, hope this one helps -
IF (@p = 'NULL' OR @p IS NULL)
BEGIN
SELECT * FROM abc WHERE name1 IS NULL
END
ELSE
BEGIN
SELECT * FROM...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 8, 2012 at 5:52 am
Please attach a screenshot of sample data or post query which you wrote so that we can do modification in that and give you desired result,
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 8, 2012 at 4:53 am
select * from abc
where column_name IS NULL
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 8, 2012 at 4:48 am
nice question
+1 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 8, 2012 at 12:57 am
wrong answer 🙁
I learned a lot from transaction questions 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 8, 2012 at 12:50 am
When 'x' is getting inserted with WITh(ignore_dup_key=ON) then in select statement why 'x' is not getting returned?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 6, 2012 at 7:47 am
hi,
Can anyone tell me How to check whether the database is in single user mode or multi user mode?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 6, 2012 at 7:40 am
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 6, 2012 at 7:29 am
Thanks for the explanation Hugo
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 6, 2012 at 7:23 am
I write that statement as there was no FROM clause in his query.
I agreed in using alias in FROM clause but he pasted query in whis he didnt...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 5, 2012 at 9:05 am
Can you please attached the screenshots of what type of error you are getting..so we can look into it in a better way
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 5, 2012 at 8:54 am
Viewing 15 posts - 1,006 through 1,020 (of 1,048 total)