emregulcan


Member since 03/01/2010

Name: Emre GULCAN

Location: Istanbul

8 snippets

3902 profile views

2 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet

emregulcan's Recent SnippetsTagged sql



« Prev 1 Next »
This snippet is "extension method" for IDataReader. You can use this snippet below ; I assume you have datareader like that SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.IsColumnExists("columnName")) { //do something...
0 1206 posted 13 years ago by emregulcan
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...
1 579 posted 13 years ago by emregulcan
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...
0 1507 posted 13 years ago by emregulcan
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())
0 564 posted 13 years ago by emregulcan
You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)
4 891 posted 14 years ago by emregulcan
This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.
2 857 posted 14 years ago by emregulcan
You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')
2 800 posted 14 years ago by emregulcan
« Prev 1 Next »