Viewing 15 posts - 61 through 75 (of 144 total)
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...
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...
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"...
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...
May 28, 2013 at 6:17 am
Danny Ocean (5/22/2013)
Basic and easy one.:-)Thanks for question !!!
+1
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...
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...
May 27, 2013 at 4:58 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...
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...
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...
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....
May 9, 2013 at 1:42 am
Viewing 15 posts - 61 through 75 (of 144 total)