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

SQL Add an user to an mysql account

mysql

0 1715 posted 18 years ago by therobot

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 2286 posted 18 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 7637 posted 18 years ago by rengber

SQL Export and import from MySQL

mysql

2 1644 posted 18 years ago by micmath

SQL Using a BitMask in a Where Clause

0 1551 posted 18 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 1874 posted 18 years ago by rengber

SQL Search Stored Procedure Code for a String

0 1589 posted 19 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 2096 posted 19 years ago by rengber

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

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