Welcome To Snipplr


Everyone's Recent SQL Snippets



If you are deleting all the rows in a table and you also want to reset the values that will get used by auto increment, this is how to do it.
0 541 posted 15 years ago by jachin
You can generate a simple bar chart of the values by executing this command...
0 556 posted 15 years ago by zingo
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 866 posted 15 years ago by rengber
0 460 posted 15 years ago by therobot
2 460 posted 15 years ago by micmath
0 386 posted 15 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 1485 posted 15 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 464 posted 15 years ago by assbach
useful if a "valid until" should have an exact ( in this case far future ) value.
0 411 posted 15 years ago by assbach
1 600 posted 16 years ago by olive
0 543 posted 16 years ago by olive
2 568 posted 16 years ago by berkes
Counts the total amout of nodeviews between now and a year ago (the last 31536000 seconds).
1 378 posted 16 years ago by berkes
Grab all users that never logged in.
1 482 posted 16 years ago by berkes
This will return the number of seconds between now and when the time field was inserted.
0 600 posted 16 years ago by wolfie
0 426 posted 16 years ago by yuconner