Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets

This is as small as this can go: 'xs:dateTime(sql:variable("@stringDate"))' It needs to be a literal string for the Value() function. Xml Datatype http://msdn2.microsoft.com/en-us/library/ms189887.aspx Sql:Variable() Function http://ms...
0 1141 posted 16 years ago by rengber
0 628 posted 16 years ago by therobot
2 618 posted 16 years ago by micmath
0 563 posted 16 years ago by rengber
First, create two new fields in your table "Created", and "LastModified" as "datetime" fields, being sure to allow nulls. Then run this code as a query to create triggers that will update the appropriate field when a record is modified, or a record...
1 1895 posted 16 years ago by jeffxl
2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days
2 653 posted 17 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 556 posted 17 years ago by assbach
1 1219 posted 17 years ago by olive
0 786 posted 17 years ago by olive
2 760 posted 17 years ago by berkes
Counts the total amout of nodeviews between now and a year ago (the last 31536000 seconds).
1 488 posted 17 years ago by berkes
Grab all users that never logged in.
1 688 posted 17 years ago by berkes
This will return the number of seconds between now and when the time field was inserted.
0 800 posted 17 years ago by wolfie
0 546 posted 17 years ago by yuconner
(taking cori comment into account)
0 596 posted 17 years ago by yuconner
0 559 posted 17 years ago by yuconner
1 565 posted 17 years ago by drdamour
mysql -u ''adminusername'' -p
0 896 posted 17 years ago by yuconner