Bee Eee Blog

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)
318 comments for this entry:
  1. CHARLIE

    ████████►BUY CIALIS◀████████…

    ▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲…

  2. CLINTON

    ████████►BUY LEVITRA◀███████…

    ▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲…

  3. ARTURO

    Abilify@official.site” rel=”nofollow”>.

    Buywithout prescription…

  4. RICARDO

    fosamax@actonel.now” rel=”nofollow”>.

    Buynow…

  5. JIMMIE

    Actos@official.site” rel=”nofollow”>..

    Buywithout prescription…

  6. JOHN

    shimmy@adalat.simone” rel=”nofollow”>..

    Buyit now…

  7. EUGENE

    Advair@official.site” rel=”nofollow”>.

    Buynow it…

  8. DARRELL

    altace@medication.now” rel=”nofollow”>…

    Buygeneric meds…

  9. KELLY

    Ampicillin@official.site” rel=”nofollow”>.

    Buynow it…

  10. CHRISTIAN

    Avelox@official.site” rel=”nofollow”>…

    Buyno prescription…

  11. LARRY

    ..

    Buygeneric drugs…

  12. ALBERTO

    Augmentin@official.site” rel=”nofollow”>.

    Buywithout prescription…

  13. RICK

    Clonidine@official.site” rel=”nofollow”>…

    Buynow…

  14. CARLTON

    abilify@vs.risperidone.dosage” rel=”nofollow”>.

    Buygeneric drugs…

  15. BRIAN

    buy@cheap.viagra.in.uk” rel=”nofollow”>.

    Buywithout prescription…

  16. KIRK

    buy@viagra.in.london.england” rel=”nofollow”>…

    Buygeneric drugs…

  17. ALVIN

    < a href="http://my.gardenguides.com/members/buy-Tramadol? buy@Tramadol.now

    Buyno prescription…

  18. ROLAND

    prozac@dangers.now” rel=”nofollow”>..

    Buygeneric drugs…

  19. DOUGLAS

    Abilify@official.site” rel=”nofollow”>…

    Buynow…

  20. HUBERT

    Abilify@official.site” rel=”nofollow”>…

    Buynow it…

  21. DARRYL

    depakote@parkinsonism.now” rel=”nofollow”>.

    Buyit now…

  22. DENNIS

    Depakote@official.site” rel=”nofollow”>.

    Buygeneric drugs…

  23. REX

    Zoloft

    Buygeneric drugs…

  24. NEIL

    Zocor

    Buygeneric drugs…

  25. KARL

    Vitamin B

    Buydrugs without prescription…

  26. ALFONSO

    Zyvox

    Buydrugs without prescription…

  27. KELLY

    Retin A

    Buygeneric drugs…

  28. DONNIE

    purim wiki

    Buydrugs without prescription…

  29. VIRGIL

    Retin A

    Buywithout prescription…

  30. LONNIE

    Remeron

    Buyno prescription…

  31. CLINTON

    Purim

    Buyno prescription…

  32. RUSSELL

    Pulmicort

    Buywithout prescription…

  33. JULIO

    Synthroid@Synthroid.Synthroid” rel=”nofollow”>.

    Buynow it…

  34. DANIEL

    Purim@Purim.Purim” rel=”nofollow”>…

    Buyno prescription…

  35. EDDIE

    Synthroid@Synthroid.Synthroid” rel=”nofollow”>..

    Buynow it…

  36. CLAUDE

    Tri@Cyclen.now” rel=”nofollow”>…

    Buyno prescription…

  37. GEORGE

    Soma@Soma.Soma” rel=”nofollow”>.

    Buyno prescription…

  38. MANUEL

    Slimfast@Slimfast.Slimfast” rel=”nofollow”>..

    Buygeneric drugs…

  39. ADRIAN

    Synthroid@Synthroid.Synthroid” rel=”nofollow”>..

    Buynow it…

  40. SAM

    Purim@Purim.Purim” rel=”nofollow”>…

    Buygeneric drugs…

  41. ANDY

    Spiriva@Spiriva.Spiriva” rel=”nofollow”>..

    Buyno prescription…

  42. LOUIS

    Synthroid@Synthroid.Synthroid” rel=”nofollow”>.

    Buyit now…

  43. EDGAR

    Singulair@Singulair.Singulair” rel=”nofollow”>…

    Buygeneric pills…

  44. TYRONE

    Prozac@Prozac.Prozac” rel=”nofollow”>.

    Buygeneric pills…

  45. MATTHEW

    Crestor@Crestor.Crestor” rel=”nofollow”>…

    Buyno prescription…

  46. TREVOR

    Prozac@Prozac.Prozac” rel=”nofollow”>.

    Buygeneric drugs…

  47. SEAN

    Singulair@Singulair.Singulair” rel=”nofollow”>.

    Buygeneric drugs…

  48. REX

    Prozac@Prozac.Prozac” rel=”nofollow”>..

    Buyit now…

  49. CHARLIE

    .

    Buygeneric drugs…

  50. RICKY

    Buygeneric meds…

  51. MELVIN

    ..

    Buywithout prescription…

  52. DONALD

    Buywithout prescription…

  53. MANUEL

    allegra@print.colorado.springs” rel=”nofollow”>…

    Buygeneric drugs…

  54. SHAUN

    what@side.effects.does.abilify.cause” rel=”nofollow”>…

    Buygeneric meds…

  55. PHILIP

    chantix@vs.zyban” rel=”nofollow”>..

    Buyit now…

  56. MARK

    retin@a.cheap.no.prescription” rel=”nofollow”>..

    Buygeneric drugs…

  57. GEORGE

    .

    Buyno prescription…

  58. JARED

    high@dose.dexamethasone.induction” rel=”nofollow”>..

    Buydrugs without prescription…

  59. ANTONIO

    aleve@active.ingredient” rel=”nofollow”>.

    Buygeneric meds…

  60. DENNIS

    dilantin@hypoglycemia.alcohol” rel=”nofollow”>…

    Buyit now…

  61. KIRK

    alternatives@to.premarin” rel=”nofollow”>…

    Buygeneric pills…

  62. ADRIAN

    altace@generic.name” rel=”nofollow”>.

    Buynow it…

  63. HECTOR

    order@altace.cod” rel=”nofollow”>..

    Buynow…

  64. MELVIN

    Buydrugs without prescription…

  65. FRANKLIN

    how@long.before.extenze.works” rel=”nofollow”>.

    Buygeneric pills…

  66. HARVEY

    flexeril@gain.weight” rel=”nofollow”>.

    Buygeneric drugs…

  67. LYNN

    premarin@cream.comments” rel=”nofollow”>…

    Buyit now…

  68. JUAN

    Buyno prescription…

  69. JAIME

    Buygeneric drugs…

  70. STEVEN

    Buy@Discount.Coral.Calcium” rel=”nofollow”>.

    Buyit now…

  71. ANGEL

    Order@Coral.Calcium.Online” rel=”nofollow”>..

    Buygeneric pills…

  72. ENRIQUE

    Buy@Abana.Online” rel=”nofollow”>.

    Buynow it…

  73. EDUARDO

    Buy@Cheap.Abana” rel=”nofollow”>..

    Buygeneric pills…

  74. LEWIS

    Order@Cheap.Abana” rel=”nofollow”>..

    Buynow it…

  75. PERRY

    Purchase@Discount.Abana” rel=”nofollow”>…

    Buywithout prescription…

  76. SALVADOR

    Buy@Abilify.Online” rel=”nofollow”>..

    Buygeneric meds…

  77. RONNIE

    Buy@Cheap.Abilify” rel=”nofollow”>..

    Buynow it…

  78. DUSTIN

    Cheap@Generic.Abilify” rel=”nofollow”>..

    Buygeneric drugs…

  79. BRANDON

    Buy@Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>..

    Buyno prescription…

  80. ROY

    Buy@Generic.Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>…

    Buywithout prescription…

  81. GUY

    Buy@Acai.Online” rel=”nofollow”>.

    Buywithout prescription…

  82. RUSSELL

    Purchase@Discount.Acai” rel=”nofollow”>..

    Buywithout prescription…

  83. SALVADOR

    Cheap@Acai.Online” rel=”nofollow”>…

    Buynow…

  84. TERRENCE

    Order@Cheap.Coral.Calcium” rel=”nofollow”>..

    Buyit now…

  85. RONALD

    Buy@Cheap.Coral.Calcium” rel=”nofollow”>…

    Buygeneric meds…

  86. JAMES

    Purchase@Coral.Calcium.Online” rel=”nofollow”>..

    Buygeneric meds…

  87. PERRY

    Purchase@Discount.Coral.Calcium” rel=”nofollow”>…

    Buygeneric pills…

  88. ARTHUR

    Cheap@Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>.

    Buygeneric meds…

  89. TRACY

    Buy@Cheap.Acai” rel=”nofollow”>…

    Buywithout prescription…

  90. RALPH

    Buy@Cheap.Acai” rel=”nofollow”>…

    Buygeneric drugs…

  91. SAMUEL

    Buy@Cheap.Acai” rel=”nofollow”>…

    Buygeneric drugs…

  92. FELIX

    Order@Acai.Online” rel=”nofollow”>…

    Buyit now…

  93. JEFFREY

    Order@Acai.Online” rel=”nofollow”>…

    Buynow it…

  94. DONALD

    Order@Acai.Online” rel=”nofollow”>…

    Buyit now…

  95. GARY

    Order@Discount.Acai” rel=”nofollow”>..

    Buywithout prescription…

  96. BYRON

    Order@Cheap.Energy.Boost” rel=”nofollow”>.…

    Buynow it…

  97. NATHAN

    Order@Discount.Energy.Boost” rel=”nofollow”>.…

    Buynow it…

  98. SAM

    Purchase@Discount.Energy.Boost” rel=”nofollow”>.…

    Buynow it…

  99. RUBEN

    Buy@Cheap.Accupril” rel=”nofollow”>.…

    Buygeneric meds…

  100. ADAM

    Buy@Discount.Accupril” rel=”nofollow”>.…

    Buyno prescription…

  101. BOB

    Order@Accupril.Online” rel=”nofollow”>.…

    Buygeneric drugs…

  102. BILLY

    Order@Discount.Accupril” rel=”nofollow”>.…

    Buygeneric drugs…

  103. BRUCE

    Order@Cheap.Accutane” rel=”nofollow”>.…

    Buygeneric drugs…

  104. KENNY

    Purchase@Cheap.Accutane” rel=”nofollow”>.…

    Buynow it…

  105. CARL

    Buy@Cheap.Aciphex” rel=”nofollow”>.…

    Buygeneric meds…

  106. WILLIAM

    Get@Aciphex.Online” rel=”nofollow”>.…

    Buygeneric pills…

  107. EUGENE

    Generic@Aciphex.20mg.Without.Prescription” rel=”nofollow”>…

    Buyno prescription…

  108. OLIVER

    Purchase@Generic.Actonel” rel=”nofollow”>.…

    Buygeneric meds…

  109. ROY

    Cheap@Actonel.Without.Prescription” rel=”nofollow”>…

    Buynow it mou…

  110. CLIFTON

    Cheap@Generic.Actonel.35mg” rel=”nofollow”>..

    Buygeneric meds qmo…

  111. DARYL

    Purchase@Discount.Actoplus.Met” rel=”nofollow”>..

    Buygeneric drugs krg…

  112. RAY

    Order@Cheap.Actos” rel=”nofollow”>.

    Buygeneric drugs zfk…

  113. LAWRENCE

    Get@Actos.Online” rel=”nofollow”>..

    Buywithout prescription dyo…

  114. MARCUS

    Buy@Generic.Actos” rel=”nofollow”>..

    Buynow it vhx…

  115. SERGIO

    Buy@Actos.Without.Prescription” rel=”nofollow”>.

    Buyno prescription luw…

  116. VICTOR

    Buy@Acular.Online” rel=”nofollow”>..

    Buygeneric pills zdg…

  117. RODNEY

    Order@Cheap.Adalat” rel=”nofollow”>..

    Buygeneric drugs lzt…

  118. LLOYD

    Buy@Cheap.Coral.Calcium” rel=”nofollow”>…

    Buywithout prescription xiu…

  119. EVERETT

    Purchase@Abilify.Without.Prescription” rel=”nofollow”>..

    Buygeneric meds abx…

  120. MELVIN

    Purchase@Generic.Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>..

    Buywithout prescription yen…

  121. LEWIS

    Buy@Discount.Acai” rel=”nofollow”>.

    Buygeneric drugs axm…

  122. MARION

    Order@Cheap.Acai” rel=”nofollow”>..

    Buyno prescription gdt…

  123. BRYAN

    Order@Discount.Acai” rel=”nofollow”>.

    Buygeneric drugs nih…

  124. MARION

    Buy@Generic.Acai” rel=”nofollow”>.

    Buygeneric drugs mby…

  125. JOEL

    Order@Generic.Acai” rel=”nofollow”>..

    Buyno prescription wkp…

  126. JERRY

    Cheap@Generic.Acai” rel=”nofollow”>…

    Buydrugs without prescription vrg…

  127. GLENN

    Cheap@Generic.Acai.500mg” rel=”nofollow”>..

    Buyno prescription tao…

  128. AUSTIN

    Order@Cheap.Accupril” rel=”nofollow”>.

    Buynow it fnp…

  129. WESLEY

    Purchase@Accupril.Online” rel=”nofollow”>.

    Buywithout prescription yyn…

  130. RONNIE

    Cheap@Accupril.Online” rel=”nofollow”>..

    Buygeneric drugs ajd…

  131. BRUCE

    Buy@Accutane.Online” rel=”nofollow”>..

    Buyno prescription jui…

  132. LEROY

    Order@Accutane.Online” rel=”nofollow”>…

    Buyit now sge…

  133. JASON

    Purchase@Cheap.Accutane” rel=”nofollow”>…

    Buywithout prescription ccw…

  134. JOHNNY

    Buy@Generic.Accutane” rel=”nofollow”>…

    Buygeneric meds svb…

  135. RONALD

    Purchase@Generic.Accutane.10mg.20mg” rel=”nofollow”>.

    Buygeneric drugs itj…

  136. MARVIN

    Order@Aciphex.Online” rel=”nofollow”>.

    Buynow it lmg…

  137. MITCHELL

    Order@Cheap.Aciphex” rel=”nofollow”>..

    Buydrugs without prescription faj…

  138. JACK

    Purchase@Discount.Acomplia” rel=”nofollow”>..

    Buyno prescription din…

  139. DUANE

    Purchase@Discount.Acomplia” rel=”nofollow”>..

    Buynow it sgk…

  140. JEREMIAH

    Purchase@Discount.Acomplia” rel=”nofollow”>.

    Buynow tqa…

  141. MILTON

    Buy@Actonel.Online” rel=”nofollow”>..

    Buydrugs without prescription hak…

  142. CARLOS

    Purchase@Actonel.Online” rel=”nofollow”>…

    Buygeneric drugs vbr…

  143. VINCENT

    Purchase@Cheap.Actonel” rel=”nofollow”>.

    Buydrugs without prescription xab…

  144. AARON

    Order@Actonel.Without.Prescription” rel=”nofollow”>..

    Buyno prescription jwi…

  145. REGINALD

    Order@Actonel.Without.Prescription” rel=”nofollow”>…

    Buydrugs without prescription jlg…

  146. GERARD

    Order@Advair.Online” rel=”nofollow”>..

    Buyit now irl…

  147. EVAN

    < a href="http://trig.com/advair5771/biography/?ml=Advair-25mcg/50mcg-25mcg/125mcg-25mcg/250mcg-50mcg/500mcg-50mcg/100mcg-50mcg/250mcg-Without-Prescription Advair@25mcg50mcg.25mcg125mcg.25mcg250mcg.50mcg500mcg.50mcg100mcg.50mcg250mcg.Without.Pr

    Buydrugs without prescription ygy…

  148. ALVIN

    Buy@Cheap.Aggrenox” rel=”nofollow”>..

    Buygeneric meds dxy…

  149. BILLY

    Get@Aggrenox.Online” rel=”nofollow”>…

    Buynow fjl…

  150. RENE

    Order@Cheap.Albenza” rel=”nofollow”>…

    Buynow it sxk…

  151. WENDELL

    hair@growth.and.accutane” rel=”nofollow”>..

    Buygeneric drugs…

  152. DARRYL

    actonel@and.heart.irregularities” rel=”nofollow”>..

    Buyno prescription…

  153. MELVIN

    aldactone@kidney.problems” rel=”nofollow”>…

    Buygeneric drugs…

  154. MICHAEL

    altace@cough.buy” rel=”nofollow”>..

    Buynow…

  155. DAN

    buy@amoxicillin.500mg” rel=”nofollow”>.

    Buynow it…

  156. JESSE

    arcoxia@120mg.buy” rel=”nofollow”>…

    Buygeneric drugs…

  157. BARRY

    risperdal@vs.abilify” rel=”nofollow”>.

    Buygeneric drugs…

  158. REX

    abilify@and.sleep.issues” rel=”nofollow”>..

    Buydrugs without prescription…

  159. CLINTON

    actonel@and.dvt” rel=”nofollow”>.

    Buygeneric meds…

  160. RICHARD

    allegra@generic.purchase” rel=”nofollow”>…

    Buynow…

  161. JOHNNY

    aloe@vera.juice.for.sale” rel=”nofollow”>..

    Buyit now…

  162. BOB

    side@effects.of.aricept” rel=”nofollow”>..

    Buyit now…

  163. FERNANDO

    arimidex@or.nolvadex.steriods” rel=”nofollow”>..

    Buywithout prescription…

  164. gerard

    Search music now US Charts…

  165. GREG

    aspirin pain relief dog

    Buy_drugs without prescription…

  166. MATT

    warfarin sod

    Buy_drugs without prescription…

  167. EDWIN

    verapamil side effects

    Buy_drugs without prescription…

  168. ANDREW

    iv zofran

    Buy_drugs without prescription…

  169. WADE

    planar warts

    Buy_drugs without prescription…

  170. KYLE

    stop smoking phlegm

    Buy_drugs without prescription…

  171. MARCUS

    hypertension police ma

    Buy_drugs without prescription…

  172. BYRON

    what foods anorexia eat

    Buy_drugs without prescription…

  173. HUGH

    depo@provera.bone.loss” rel=”nofollow”>…

    Buygeneric drugs…

  174. JOHN

    canadian@pharmacy.valtrex” rel=”nofollow”>…

    Buygeneric meds…

  175. ALLEN

    pietro@atrovent.buy” rel=”nofollow”>…

    Buygeneric meds…

  176. HENRY

    avelox@4090.mg” rel=”nofollow”>…

    Buygeneric drugs…

  177. NORMAN

    propecia@before.and.after.picture” rel=”nofollow”>.

    Buywithout prescription…

  178. BRETT

    indications@for.use.of.atrovent” rel=”nofollow”>…

    Buygeneric meds…

  179. JEREMY

    best@medicare.plan.d.for.nexium.40.mg” rel=”nofollow”>..

    Buygeneric meds…

  180. HARRY

    infant@prevacid.dose” rel=”nofollow”>.

    Buygeneric drugs…

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...