Viewing 15 posts - 58,396 through 58,410 (of 59,048 total)
Sure, Dennis... having a bit of a lack of sleep going on myself, here's an example using the Northwind database...
USE NorthWind
DECLARE @Year CHAR(4)
SET @Year...
February 3, 2006 at 8:11 pm
Concur... doesn't sound like the Developer ever heard of the IDENTITY property of a column. Using the IDENTITY property does have some other uses, as well... think of it as...
February 3, 2006 at 5:52 pm
I just gotta remember to read the last page
... Serqiy already made a similar suggestion. Guess a concurrence never hurts though...
February 2, 2006 at 6:52 pm
This will successfully convert characters in the DD/MM/YYYY format into a DateTime datatype without much fanfare...
CONVERT(DATETIME, yourstringdate, 103)
Here's an example you can try...
DECLARE @ddmmyyyyString CHAR(10)
SET...
February 2, 2006 at 6:48 pm
I dunno... 6 bytes, 4 bytes, 8 bytes... for me, I'd still be tempted to use DateTime just because of all the things you can do with DateTime functions without...
February 2, 2006 at 6:39 pm
I agree... BCP is a great tool especially when you learn how to use the format files. You could also try a simple OSQL call using the SELECT of your...
February 2, 2006 at 6:23 pm
Great article! And, I didn't like the Merge Into function anyway... ![]()
January 30, 2006 at 11:12 pm
Jesper, thanks for pulling me off the ceiling... you're the best.
January 30, 2006 at 9:41 pm
Yep... I agree with Trigger... don't ever use @@IDENTITY because if a trigger fires and that trigger inserts into another table, @@IDENTITY will not contain the value you think it...
January 30, 2006 at 8:12 pm
Ummmm.... you could us sp_lock to see if the table is being worked on by the type of lock it has. You would, of course, need to know the ID...
January 30, 2006 at 8:08 pm
You bet, Charles. Thank you for the feedback.
January 30, 2006 at 8:02 pm
Great idea... a word of caution, though. I've found that sp_Depends will sometimes miss things... I believe that problem is also documented (somewhere) on this forum. Not sure if they...
January 30, 2006 at 4:02 am
Viewing 15 posts - 58,396 through 58,410 (of 59,048 total)