Viewing 15 posts - 526 through 540 (of 551 total)
thank you Antony. (yes, R2 is different, 2008 and 2008 R2 needs to be treated as two different things)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 4:45 am
Sorry for this off-topic question.
I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.
Just wanted to know, now I see that SP2...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 4:08 am
Thank you Keon.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 2:53 am
anthony.green (2/24/2012)
Raghavendra Mudugal (2/24/2012)
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 2:47 am
SQL Version
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 2:39 am
YAY!!!. I got one point.
(representation of N - has nothing to do with the collation)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 23, 2012 at 2:52 am
I selected "NO and NO" 🙁
NoteToSelf: When it says R2 then refer only the R2-BOL. Referring 2005-BOL will not help.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 22, 2012 at 7:24 am
I have seen saying that using NOLOCK is good sign of the poor design.
In my current work, we use NOLOCK in all SQL statements, (I know its not good)
from the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 14, 2012 at 3:17 am
SathishK (2/10/2012)
Raghavendra Mudugal (2/10/2012)
cengland0 (2/10/2012)
Raghavendra Mudugal (2/10/2012)
cengland0 (2/10/2012)
Steve Jones - SSC Editor (2/9/2012)
SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname) FROM Employees
In this case, without access to the code, it...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 10, 2012 at 9:24 am
cengland0 (2/10/2012)
Raghavendra Mudugal (2/10/2012)
cengland0 (2/10/2012)
Steve Jones - SSC Editor (2/9/2012)
SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname) FROM Employees
In this case, without access to the code, it becomes hard to...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 10, 2012 at 4:51 am
cengland0 (2/10/2012)
Steve Jones - SSC Editor (2/9/2012)
SELECT HASHBYTES( 'SHA1', 'R@nd0m' + Pwd + firstname) FROM Employees
In this case, without access to the code, it becomes hard to determine what the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 10, 2012 at 3:44 am
0xB9A02E529093456D139C69FC5E5D4D825B7EC24B0xCDE457DD8AB6C020E9852FE5B6953E02631A2CB2
this is the output of your query, just wanted to know what you mean by "exact same results"....?
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 9, 2012 at 3:45 am
For me this question did not made any sense.
the sample code is just concatenating another variable to it, you can name it @salt to @sugar... still the sample code will...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 9, 2012 at 2:56 am
To be honest, I took the article by very surprise.
Currently I am working as an Application Support (IT section) in a Shipping company. From the 6.5 to 2012...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
January 15, 2012 at 10:36 am
G'Day! Bert!
Thanks a lot.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
March 3, 2010 at 9:41 pm
Viewing 15 posts - 526 through 540 (of 551 total)