Viewing 15 posts - 31 through 45 (of 355 total)
Hugo Kornelis (2/14/2012)
cengland0 (2/14/2012)
February 14, 2012 at 3:01 am
Thanks for the great question. Couple points:
1. I thought both statements were exactly the same. I sat there looking at it for about 4 minutes before I...
February 14, 2012 at 2:49 am
Cliff Jones (2/13/2012)
February 14, 2012 at 2:35 am
SQL Kiwi (2/13/2012)
cengland0 (2/13/2012)
What other ways can you change the entire contents of a table and still have the reports available without dirty data?
Aside from the VIEW suggestion, similar alternatives...
February 13, 2012 at 6:45 am
SQL Kiwi (2/13/2012)
Hugo Kornelis (2/13/2012)
I didn't check it, but I fully expect an ALTER VIEW statement to require an exclusive schema lock.
This is true, but it's not really a problem...
February 13, 2012 at 6:38 am
This was a good question. I like how it was written in the terms of a real problem to solve.
What other ways can you change the entire contents of...
February 13, 2012 at 2:43 am
Raghavendra Mudugal (2/10/2012)
(your comments has created...
February 10, 2012 at 9:43 am
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 determine...
February 10, 2012 at 4:03 am
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 input...
February 10, 2012 at 3:32 am
GSquared (2/8/2012)The best bet is, if the database is on their server instead of yours, assume they know everything about it. Since it's impossible to stop them from finding...
February 8, 2012 at 9:41 am
Hugo Kornelis (2/8/2012)
You are aware that mainstream support for SQL Server 2005 has already ended, are you? I'd consider upgrading, if I were you... :hehe:
You're right that the ideal situation...
February 8, 2012 at 3:45 am
GSquared (2/6/2012)
February 6, 2012 at 7:18 am
jcb (2/6/2012)
Some app use, at least, parameterized dynamic sql and it blocks most problems with...
February 6, 2012 at 6:12 am
jlennartz (2/3/2012)
Good question as it led to alot of interesting discussion which is usually the most interesting part of the QoTD's.
I learn much more through the QOTD discussions than I...
February 3, 2012 at 2:39 pm
jcb (2/3/2012)
I dislike using dynamic SQL but for .net I sugest using @String sqlcode = @" /*this
ill keep
the break lines
no need to fancy concatenations */
select *
from
mytable
where
myfavoritesqlresource = 'SSC';
";
😎
I just...
February 3, 2012 at 10:55 am
Viewing 15 posts - 31 through 45 (of 355 total)