emregulcan


Member since 03/01/2010

Name: Emre GULCAN

Location: Istanbul

8 snippets

462 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 201 posted 9 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 49 posted 9 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 182 posted 9 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 51 posted 9 years ago by emregulcan
You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)
4 121 posted 10 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 127 posted 10 years ago by emregulcan
You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')
2 91 posted 10 years ago by emregulcan
« Prev 1 Next »