June 22

Checking a column name existing in database schema or not

this is sql snippets which help you to find out where a specific column exist in a database or not. it is very useful when you are working on large database and have no idea is this column exist or not. this will provide you information about all tables which are using this column

Continue Reading
July 31

Create stored procedure for pagination large records

Today i will show you how you can create stored procedure for large records with pagination. What you need to do is to pass page size and page number of the page on which you show to record it will send you records accordingly. Pagination is necessary for showing large amount of records on web.

Continue Reading