Viewing 15 posts - 61 through 75 (of 145 total)
nice question... 😀
Manik
You cannot get to the top by sitting on your bottom.
July 16, 2013 at 5:22 am
Louis Hillebrand (6/11/2013)
The final select returns '10' and '2012-10-10'Louis.
+1....
First 2 statements give me error.. but Third statement is success and give result set..
There is no any conversion error...
Manik
You cannot get to the top by sitting on your bottom.
June 12, 2013 at 4:37 am
Carlo Romagnano (6/5/2013)
From BOL:
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly...
Manik
You cannot get to the top by sitting on your bottom.
June 5, 2013 at 3:03 am
Lokesh Vij (6/3/2013)
Srinivas.Pendyala (6/3/2013)
what about the 5 th value,why it is not giving output of 5?
Srinivas, The idea here is we are using "TOP(6) WITH TIES", initially "TOP 6"...
Manik
You cannot get to the top by sitting on your bottom.
June 4, 2013 at 4:44 am
CREATE TABLE #temp
(
ID int PRIMARY KEY,
Name varchar(900)
CONSTRAINT UN_Name UNIQUE(Name)
);
The #temp table created with 900 bytes, but
CREATE TABLE #temp
(
ID int PRIMARY KEY,
Name varchar(1000)
CONSTRAINT UN_Name UNIQUE(Name)
);
if i try to...
Manik
You cannot get to the top by sitting on your bottom.
May 28, 2013 at 6:17 am
Danny Ocean (5/22/2013)
Basic and easy one.:-)Thanks for question !!!
+1
Manik
You cannot get to the top by sitting on your bottom.
May 27, 2013 at 7:05 am
Hugo Kornelis (5/23/2013)
I knew that neither statement would execute when sent as a single batch.
I didn't understand this part. can you...
Manik
You cannot get to the top by sitting on your bottom.
May 27, 2013 at 5:13 am
EXCEPT returns any distinct values from the left query that are not also found on the right query. The key to this is of course the use of DISTINCT.
Really...
Manik
You cannot get to the top by sitting on your bottom.
May 27, 2013 at 4:58 am
nice basic question....:-)
Manik
You cannot get to the top by sitting on your bottom.
May 27, 2013 at 4:54 am
If more than one temporary table is created inside a single stored procedure or batch, they must have different names
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/1e068443-b9ea-486a-804f-ce7b6e048e8b.htm
Obviously SQL Server does not care if the two create table...
Manik
You cannot get to the top by sitting on your bottom.
May 27, 2013 at 4:49 am
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 message that...
Manik
You cannot get to the top by sitting on your bottom.
May 27, 2013 at 4:36 am
Danny Ocean (5/10/2013)
Good question, but Explanation is not completed or require more details.I think hugo can help us.
thanks... nice question...
Manik
You cannot get to the top by sitting on your bottom.
May 16, 2013 at 3:28 am
Danny Ocean (5/8/2013)
unfortunately, i trapped in this question. :crying:But i learn something new. 🙂
Thanks reddy
me too.. But it will be helped in my future...
thanks nice question....
Manik
You cannot get to the top by sitting on your bottom.
May 9, 2013 at 1:42 am
nice and easy question....
Manik
You cannot get to the top by sitting on your bottom.
May 8, 2013 at 7:30 am
nice question....
Manik
You cannot get to the top by sitting on your bottom.
May 8, 2013 at 7:11 am
Viewing 15 posts - 61 through 75 (of 145 total)