/* Author : Abhishek Joshi SP Name : usp_Quoter_ListAll Date : 15 Feb, 2007 Desc : Select all [...]
Archive for February, 2007
Use Custom Paging in Asp.Net With Page Size (Faster Performance)
Posted in Paging on February 28, 2007 | Leave a Comment »
Use Index and Cursor in SQL Server 2000
Posted in Cursor, Index, Sql Server on February 27, 2007 | 1 Comment »
Using Index ================select *from ZIPCodes where StateName = ‘New York’
– Create Indexcreate nonclustered index idxStateName on ZIPCodes(StateName)create nonclustered index idxZIPType on ZIPCodes(ZIPType)
– Use Indexselect *from ZIPCodes with(INDEX(idxZIPType)) where ZIPType = ‘S’
– List of Indexes on Perticular Tableexec sp_helpindex ‘ps_client_master’
– Drop Indexdrop index ps_client_master.ps_client_master_Index_1
Using Cursors===============
DECLARE @ClientID char(11)
declare cl CURSOR FOR select int_id from [...]
