Viewing 15 posts - 631 through 645 (of 825 total)
Toreador (6/24/2011)
I wonder which of the following (if either) is more efficient:
select @a = 1 where @b = 0or
if @b = 0 set @a = 1
"if" runs better
declare @d datetime
,@a...
June 24, 2011 at 9:46 am
If the condition of the WHERE clause validates to true then the result set is returned. If it does not, the result set is empty.
This is true only if...
June 23, 2011 at 1:27 am
Do you mean that for SA you get e.g. 2011-05-26 14:15:37 and for CARLO you get 1900-01-01 02:00:00?
Yes, exactly!
May 26, 2011 at 10:06 am
michael.kaufmann (5/26/2011)
Carlo Romagnano (5/26/2011)
1900-01-01 02:00:00.000
Step 1: bad password attempt
Step 2: correct login
I run the query: SELECT...
May 26, 2011 at 6:24 am
-- to see all bad attempts
SELECT l.name, loginproperty(l.name, 'BadPasswordTime')
FROM sys.syslogins l
May 26, 2011 at 2:01 am
In sql2005, I tried with other logins than sa and I get always the following:
1900-01-01 02:00:00.000
Step 1: bad password attempt
Step 2: correct login
I run the query: SELECT loginproperty('carlo', 'badpasswordtime')
The result:...
May 26, 2011 at 1:50 am
Koen Verbeeck (5/16/2011)
And the explanation doesn't mention why inserting NULL in another string doesn't result in NULL, but in an empty space instead.
I am curious: bol does not mention the...
May 17, 2011 at 1:14 am
SQLRNNR (5/4/2011)
I like it too. I also like that the R2 doc seems better written on this topic than the SQL 2008 doc
I agree with you! 😀
May 5, 2011 at 12:52 am
In addition, the administrator should disable in AD and kill all disabled-user's connections.
April 22, 2011 at 1:20 am
It's a good habit always to specify precision and scale because of changing default in future releases.
April 18, 2011 at 1:13 am
Steve Jones - SSC Editor (4/12/2011)
You do not have to post to get points...
April 13, 2011 at 2:57 am
Thank you very much for this beautiful qotd.
It's unbelievable, but true, only new types DATE and DATETIME2 work in any case.
April 13, 2011 at 1:29 am
Viewing 15 posts - 631 through 645 (of 825 total)