Viewing 15 posts - 181 through 195 (of 205 total)
SELECT DATEADD(day, DATEDIFF(day, '20100101', CURRENT_TIMESTAMP), '20100101');
The only thing I don't like about this method is the hard-coded string. I suppose a dynamic expression could replace it but it would...
September 1, 2010 at 7:45 am
mbova407 (9/1/2010)
DECLARE @a INT
DECLARE @b-2 DATETIME
set @b-2 = GETDATE()-.5
September 1, 2010 at 7:00 am
I guess if we really want to split hairs and get technical, it is possible to drop tempdb. Stopping and starting the SQLService or rebooting the server will result...
August 20, 2010 at 6:38 am
Nice question. Had to jump start the grey matter first thing in the morning to get this one.
I especially appreciated all the neatly terminated statements. 😉
August 3, 2010 at 6:40 am
Hugo Kornelis (7/13/2010)
...I hope the author will stop by and tell us what he/she was trying to teach us with this question. Maybe I missed the deeper issue here.
I actually...
July 13, 2010 at 8:17 am
I'm not too sure this was really a bad question. We've seen questions receive a lot more positive feedback that were only worth 1 point. So if this...
June 11, 2010 at 6:39 am
I've been in the IT field for about a quarter of a century. I do about 2 weeks of development and SQL Server training per year. I finished...
April 14, 2010 at 6:29 am
Very interesting question. I found that adding this case:
SELECT 'E' FROM @T WHERE A IS NULL;
will return a row with ANSI_NULLS ON or OFF. This may be the...
April 7, 2010 at 6:44 am
You got me all the way to the end. 😛
I guess the reason I didn't consider that it could be a joke is because of my days working with PeopleSoft...
April 1, 2010 at 6:40 am
nigelg99 (3/24/2010)
Yes, it is version 10.0.2531.0. I don't remember changing it, but I can see that there is an option (Options->Text Editor->All Languages) called "Enable single-click URL navigation". ...
March 24, 2010 at 1:07 pm
nigelg99 (3/24/2010)
I use SSMS 2008 and I get the pop-up....
That's interesting since a number of people have posted that with SSMS 2008 no pop-up happens. Are you using 10.0.2531? ...
March 24, 2010 at 10:53 am
sknox (3/24/2010)
SSMS 2005 - popup came up "CTRL-Click to open...", CTRL-click opens in a new tab.
SSMS 2008 - NO POPUP, CTRL-click opens in a new tab.
So I'm guessing they removed...
March 24, 2010 at 8:08 am
I had the same experience I see a lot of others posting.
With a SQL Server 2008 installation on a machine with Internet Explorer as the default browser and access to...
March 24, 2010 at 8:01 am
I couldn't agree more that "it depends" is going to be the rule for this one. So I'll just share from my own experiences. Over the last 25...
March 23, 2010 at 6:52 am
Test it? Isn't putting it into production the way to test things? :hehe:
March 17, 2010 at 6:58 am
Viewing 15 posts - 181 through 195 (of 205 total)