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

SQL Add an user to an mysql account

mysql

0 1493 posted 18 years ago by therobot

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 2087 posted 18 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 7343 posted 18 years ago by rengber

SQL Export and import from MySQL

mysql

2 1457 posted 18 years ago by micmath

SQL Using a BitMask in a Where Clause

0 1381 posted 18 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 1667 posted 18 years ago by rengber

SQL Search Stored Procedure Code for a String

0 1427 posted 18 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 1906 posted 18 years ago by rengber

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

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