Profile
Achievement
emregulcan's Recent SnippetsTagged sql
- All /
« 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