Snipplr

(SQL) Search for text in all db objects in database - hairajeshk

Mon, 21 Jul 2014 17:24:45 UTC

from codeproject

(SQL) Visual Representation of SQL Joins - hairajeshk

Mon, 11 Mar 2013 17:53:10 UTC

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

(SQL) get all children under a tree - hairajeshk

Wed, 23 Jan 2013 23:53:23 UTC

to fetch all the children in a tree based on parentid

(SQL) Iterating through wihle loop in sql server like cursor - hairajeshk

Wed, 10 Oct 2012 16:05:25 UTC

http://support.microsoft.com/kb/111401

(SQL) How to select the first/least/max row per group in SQL - hairajeshk

Fri, 08 Jul 2011 14:45:56 UTC

max value record for each group

(SQL) Dynamic sql more than 4000 chars - hairajeshk

Thu, 07 Apr 2011 20:45:14 UTC

(SQL) Errors and Resolutions - hairajeshk

Mon, 24 Jan 2011 20:16:16 UTC

Errors and Resolutions

(SQL) To make an SP Recompile - hairajeshk

Fri, 17 Dec 2010 17:27:01 UTC

(SQL) Check Constraint - Calling function under Check constraint - hairajeshk

Thu, 02 Dec 2010 23:06:55 UTC

If we don't have a primary key and unable to create a foreign key

(SQL) Find sp or table name in all stored procs - hairajeshk

Tue, 09 Nov 2010 21:44:45 UTC

(SQL) SSRS Subscription options - hairajeshk

Tue, 19 Oct 2010 12:53:01 UTC

SSRS Subscription options

(SQL) Creating Index on Large Text columns - hairajeshk

Thu, 16 Sep 2010 22:42:51 UTC

Creating index on huge text columns

(SQL) Check temporary table exists - hairajeshk

Wed, 15 Sep 2010 21:21:56 UTC

Verify whether temporary table created is exists or not

(SQL) Find Column Name in all tables in a Database - hairajeshk

Wed, 15 Sep 2010 15:42:26 UTC

Find column name in all tables of a database

(SQL) Import data into SQL Server using the ad hoc distributed queries from Excel - hairajeshk

Wed, 04 Aug 2010 16:35:43 UTC

Import data into SQL Server using the ad hoc distributed queries from Excel

(SQL) Stop the transaction log of a SQL Server database from growing unexpectedly - hairajeshk

Wed, 04 Aug 2010 16:33:07 UTC

Stop the transaction log of a SQL Server database from growing unexpectedly

(SQL) Script Generating for each object individually - hairajeshk

Wed, 04 Aug 2010 16:32:13 UTC

Generate script for each individual object in each individual file (sample application present at this location)

(SQL) Delete all dependent rows in all the other tables - hairajeshk

Wed, 04 Aug 2010 16:31:16 UTC

delete all the dependent rows in all the other tables (like cascade option)

(SQL) Save script for each object in individual files - hairajeshk

Wed, 04 Aug 2010 16:30:26 UTC

Save script for each object in individual files

(SQL) Find users logged in to sql server in the previous days - hairajeshk

Wed, 04 Aug 2010 16:29:45 UTC

To know who are the users logged in to sql server in te past previous days.

(SQL) Replace characters by position in a string. - hairajeshk

Wed, 04 Aug 2010 16:28:42 UTC

Replace characters by position in a string.