Welcome To Snipplr
Everyone's Recent SQL Snippets
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
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
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
Counts the total amout of nodeviews between now and a year ago (the last 31536000 seconds).
1
378
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