January 24, 2013

SQL - TRUNCATE/DELETE/DROP tables referenced by a foreign key constraint

›
  Download Sample This article explains how to delete/truncate/drop without affecting schema properties (disabling constraints), even t...
December 31, 2012

C# - SQL Helper Class

›
Below I have mentioned my SQL Helper class that is used to communicate SQL in better way. using System; using System.Data; using S...
8 comments:

SQL Server - Generate data script for a table, conditionally

›
While Data migration or Project Release, we use Generate data script frequently. For taking whole data means we can use “ Tasks -> Gene...
December 27, 2012

InterView - Quickest Way to Find Prime Numbers

›
This week one of my college conducting interview for fresher candidates, One question i have heard, "Write a program to Find Prim...
1 comment:
December 6, 2012

Interview - Quickest Way to Get nth Maximum Value From a Table

›
Now-a-days   "Query to find 2nd Maximum value  or Nth Maximum value from a table" are a common questions in interviews. Here I...
November 28, 2012

C# - Accessing Remote File By Using Impersonation

›
Sometime we may face “Could not create the file” or “Access denied on 'Some file Name' ” or "Unable to copy file. Access to t...
6 comments:
November 26, 2012

Fixed - AJAX AsyncFileUpload is Not Working in IE9

›
Today i got a mail from client, says that " File Upload functionality not seems working. " I went to site and find out.   ...
1 comment: