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 1387 posted 17 years ago by rengber

SQL Add an user to an mysql account

mysql

0 855 posted 17 years ago by therobot

SQL Simple Technique to Subtract Years from an Oracle Date

Oracle

0 1299 posted 17 years ago by rengber

SQL List all Stored Procedures in an Oracle Database

0 6356 posted 17 years ago by rengber

SQL Export and import from MySQL

mysql

2 807 posted 17 years ago by micmath

SQL Using a BitMask in a Where Clause

0 783 posted 17 years ago by rengber

SQL Update Trigger to Increment a Version Number Column

database

0 959 posted 17 years ago by rengber

SQL Search Stored Procedure Code for a String

0 870 posted 17 years ago by rengber

SQL Get the Code of a Stored Procedure as Text

0 1044 posted 17 years ago by rengber

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

0 1127 posted 17 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...