Viewing 15 posts - 586 through 600 (of 3,221 total)
Once again I looked at my notes and here is the link
Posted 11/15/2011 1:34 PM
http://www.sqlservercentral.com/Forums/Topic1205649-1222-2.aspx
Mr Hugo Kornelis comment is
in my display mode is at the bottom of...
March 8, 2012 at 9:29 pm
Once again I looked at my notes and here is the link
Posted 11/15/2011 1:34 PM
http://www.sqlservercentral.com/Forums/Topic1205649-1222-2.aspx
Mr Hugo Kornelis comment is
in my display mode is at the bottom of...
March 8, 2012 at 9:28 pm
Evil Kraig F (3/8/2012)
L' Eomot Inversé (3/8/2012)
mtillman-921105 (3/6/2012)
Look, the first invisible car?I think it might create some problems if those were let loose in traffic.;-)
I want two... I know I'm...
March 8, 2012 at 3:59 pm
This slight modification works for me
IF DATEDIFF(ss,@create_timestamp,@modify_timestamp)> 1
BEGIN
PRINT 'GOT IT'
END
ELSE
PRINT 'WHOOPS'
March 8, 2012 at 3:43 pm
Nah do it the easy way .. go the the view .. change the word CREATE to ALTER .. run the code .. then go back to the view and...
March 7, 2012 at 2:34 pm
Congratulations .. I know from experience putting on a SQL Sat is indeed almost a full time job. I hope your presentations were well received ..
March 7, 2012 at 1:23 pm
From BOL @@IDENTITY
Is a system function that returns the last-inserted identity value.
Now is that what you want ... ?
I am thinking that you want the value AFTER the insert...
March 7, 2012 at 10:55 am
If that could not get their stuff correct the first time makes you wonder how "corrent" the individual content will be. Or is really just a concentrated sales push...
March 7, 2012 at 10:50 am
Nils Gustav Stråbø (3/6/2012)
I see that I have failed BIG TIME in my first attempt to be a QOTD whining pedantic :crying:I promise to never try to be one again...
That...
March 6, 2012 at 5:51 am
Nice question - gets one back to the basics, which unfortunately we tend to forget.
March 3, 2012 at 3:09 pm
Now I have not had the opportunity to check this suggestion, but it might be worth testing for your use
--Creating the command string
DECLARE @IdNbr VARCHAR(50)
SET @IdNbr = '312012145014'
set @sql...
March 2, 2012 at 8:04 am
If memory serves me correctly, I remember this from a long time ago.
Openrowset() (or any ad-hoc function) does not accept variable parameter.
They only take literal string.
Afterall, these are pass-through functions
And...
March 1, 2012 at 3:56 pm
Lynn Pettis (3/1/2012)
Jack Corbett (3/1/2012)
Lynn Pettis (2/24/2012)
March 1, 2012 at 10:45 am
Viewing 15 posts - 586 through 600 (of 3,221 total)