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 array c forms

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 2557 posted 19 years ago by rengber

SQL Add an user to an mysql account

mysql

0 1952 posted 19 years ago by therobot

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 2516 posted 19 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 8421 posted 19 years ago by rengber

SQL Export and import from MySQL

mysql

2 1898 posted 19 years ago by micmath

SQL Using a BitMask in a Where Clause

0 1783 posted 19 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 2132 posted 19 years ago by rengber

SQL Search Stored Procedure Code for a String

0 1739 posted 19 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 2340 posted 19 years ago by rengber

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

0 2603 posted 19 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...