MS SQL tricks for uniqueidentifers or Guid and date time.
by brian on Oct.29, 2008, under mmsql
In MS SQL Server 2005 the following code is how to get a new uniqueidentifier, and the current date and time.
SELECT newid(),getdate()
Produces these results.
------------------------------------ ----------------------- 125700F3-8FB8-496F-8EA4-35D9CB9E8415 2008-10-29 13:09:54.557 (1 row(s) affected)
1 comment for this entry:
-
Welcome
Welcome to the feed Bee Eee blog. Hope you enjoy the tips and information that's interesting to me.
Sick of trying to qualify for that auto loan? Let the loan officers bid to give you a loan! It's free and could land you that loan that you really need! 
August 30th, 2010 on 4:59 am
electric http://jbathroompff.04FORDPARTS.US/tag/Cordless+electric+Electric/ : Cordless…
electric…