Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

sql page server Oracle mysql csv database wordpress error php code drupal date replace script security search xml function text order textmate update file query data list table excel backup customer load login ASP codeigniter magento simple user windows convert joomla math find copy json Business directory number path images Online log links template link Development api twitter best web format object cache mail email html javascript actionscript apache color download service android animation browser aspnet ajax

Welcome To Snipplr

Everyone's Recent SQL Snippets

« Prev 1 ... 14 15 16 17 18 Next »

SQL TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime

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 1808 posted 18 years ago by rengber

SQL Add an user to an mysql account

mysql

0 1221 posted 18 years ago by therobot

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 1792 posted 18 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 6972 posted 18 years ago by rengber

SQL Export and import from MySQL

mysql

2 1228 posted 18 years ago by micmath

SQL Using a BitMask in a Where Clause

0 1161 posted 18 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 1411 posted 18 years ago by rengber

SQL Search Stored Procedure Code for a String

0 1202 posted 18 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 1566 posted 18 years ago by rengber

SQL Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

0 1716 posted 18 years ago by rengber

SQL Created Date & Last Modified Date Triggers

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...