Snipplr

(SQL) SQL Inserted Trigger - emregulcan

Wed, 09 Feb 2011 14:09:14 UTC

This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier) If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity . So, I write a trigger on my table to get last record guid info ;)

(SQL) sql Raiserror with parameters - emregulcan

Fri, 04 Feb 2011 11:48:41 UTC

You can see details on http://msdn.microsoft.com/en-us/library/ms178592.aspx , but I try to explain how you throw error with "uniqueidentifier" type parameters. I convert uniqueidentifier to string (nvarchar(50)) and set a variable. "%s" is equal to "string"

(SQL) SQL Trim Function - emregulcan

Sat, 11 Dec 2010 11:06:27 UTC

Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction. It's very basic; -First; it's Right Trim (RTrim()) string - And then Left Trim (LTrim())

(SQL) Find string anywhere in Sql Database - emregulcan

Mon, 02 Aug 2010 16:55:37 UTC

(SQL) Timezone database - emregulcan

Fri, 23 Jul 2010 17:43:02 UTC

You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)

(SQL) Clean SQL Injection from your tables - emregulcan

Tue, 29 Jun 2010 22:58:49 UTC

This snippet just updates your tables which infected "" code blocks. You must update all columns one by one.

(SQL) Clean Injection from Database Tables - emregulcan

Tue, 15 Jun 2010 08:21:53 UTC

You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '','')

(SQL) Find Tables in Database (SQL Query) - emregulcan

Tue, 20 Apr 2010 03:56:52 UTC