Viewing 15 posts - 121 through 135 (of 552 total)
Thank you for the post, Steve, good one.
(but confusing... for me. I like to see an example of printf style and then the same written in throw line. I thought...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 10, 2014 at 3:48 am
cdesmarais 49673 (10/9/2014)
.... You need to check your error state and explicitly rollback or commit. ..."
+1
I do that. Sometimes I have write a script where it also contains...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 9, 2014 at 11:54 am
Thank you for the post, Steve, very important one.
TRY/CATCH first choice - or go classic (sql 2000 way, it works) store the error status in the variable on each DML...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 9, 2014 at 6:24 am
Thank you for the post, Steve, interesting one.
(I have not used OUTER apply and was sure of the CROSS, so the choice was easy for me, I made the selection,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 8, 2014 at 7:41 am
Thank you for the post, Steve, nice one.
(first I saw the options and saw 16 there and then selected it as "cool... sweet 16"... and submitted, then I read the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 6, 2014 at 6:50 am
Thank you for the post, Steve, good one.
Happy weekend!!!
(To all Indians out there - Happy Dussehra)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 3, 2014 at 12:50 am
Thank you for the post, Steve, good one.
Well, this was bit challenging one for me especially when you are working in cmd mode, but after generating few errors manually...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 2, 2014 at 7:41 am
Thanks for the question Steve, very interesting one.
At first, I did not see the difference in RANK and the DENSE_RANK for the given data ...
1> CREATE TABLE custsale
2> (...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
October 1, 2014 at 7:46 am
Koen Verbeeck (9/26/2014)
It's all about the surface area 🙂
+1
I was reading the book on sql 2012 internals by Kalen Delaney, one of the line it states "It reduces the maintenance...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 26, 2014 at 9:40 am
Thank you for the post, good one. (guessed the answer right also the explanation behind it)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 22, 2014 at 3:26 am
Thanks for the post, very interesting one. I referred the local_help to know the difference between these two, and picked the geography, it states clearly on what type of data...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 19, 2014 at 9:23 am
Thank you for the post, Steve, interesting one, I never tried this before, so had to check practically.
I started the service via powershell, then launched the cmd window and then,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 17, 2014 at 8:52 am
SqlMel (9/16/2014)
Hany Helmy (9/16/2014)
Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.+ 1
+ select floor(log(square(POWER(substring (cast (1000 as varchar(10)),1,1),5000))*3))
ctrl+c
ctrl+v
(sql is so beautiful)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 16, 2014 at 7:49 am
Thank you, Steve, good one.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 15, 2014 at 7:23 am
Thank you for the post, steve, good one. (Selected the correct answer by experience)
Happy weekend.:-)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2014 at 3:45 am
Viewing 15 posts - 121 through 135 (of 552 total)