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 1140 posted 16 years ago by rengber
0 625 posted 16 years ago by therobot
2 618 posted 16 years ago by micmath
0 561 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 1892 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 651 posted 17 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 554 posted 17 years ago by assbach
1 1219 posted 17 years ago by olive
0 783 posted 17 years ago by olive
2 759 posted 17 years ago by berkes
Counts the total amout of nodeviews between now and a year ago (the last 31536000 seconds).
1 485 posted 17 years ago by berkes
Grab all users that never logged in.
1 684 posted 17 years ago by berkes
This will return the number of seconds between now and when the time field was inserted.
0 799 posted 17 years ago by wolfie
0 541 posted 17 years ago by yuconner
(taking cori comment into account)
0 592 posted 17 years ago by yuconner
0 555 posted 17 years ago by yuconner
1 564 posted 17 years ago by drdamour
mysql -u ''adminusername'' -p
0 894 posted 17 years ago by yuconner