Viewing 15 posts - 10,966 through 10,980 (of 59,064 total)
October 10, 2018 at 9:14 am
October 10, 2018 at 8:32 am
Keith Oliver - Wednesday, October 10, 2018 7:58 AMDECLARE @ndate nvarchar(50) = N'2010/03/15 01'
SET @Ndate = @ndate + ':00:00'
SELECT CONVERT(datetime, @ndate, 101)
The...
October 10, 2018 at 8:30 am
SELECT CONVERT(DATETIME,REPLACE('03\15\2010 01'
October 10, 2018 at 7:52 am
I think that's above my SQL knowledge unfortunately. I'll do it the...
October 10, 2018 at 7:46 am
Grant Fritchey - Wednesday, October 10, 2018 5:16 AMTry the veal.
😀
October 10, 2018 at 7:27 am
October 10, 2018 at 7:26 am
Let's consider what can actually happen with some software that's actually capable of monitoring "enterprise wide" or even just "domain wide" if someone learns the password(s) for the user login(s)...
October 10, 2018 at 6:47 am
October 10, 2018 at 6:29 am
October 10, 2018 at 6:11 am
Heh.... on the humorous side, I'd say both words were appropriate considering some of the DBA candidates I've interviewed where I was left wondering how they managed to administer anything....
October 9, 2018 at 10:27 pm
I know this is a common problem but I just don't see how folks...
October 9, 2018 at 10:16 pm
And I disagree with NOLOCK being useless (although it should be WITH (NOLOCK)). It does have its uses.
October 9, 2018 at 10:09 pm
VARCHAR(1) or NVARCHAR(1) (or most anything less than 10 characters but especially for 1 character.
WHERE ISNULL(somecolumn,0) > 0
WHERE somecolumn IS NOT NULL AND somecolumn > '...
October 9, 2018 at 10:05 pm
Viewing 15 posts - 10,966 through 10,980 (of 59,064 total)