August 24, 2005

Suppose you need to prevent the derivation of a class?like in the final classes of Java. Simply make the constructor of the class private. Here’s an example: class final{private: final(){}

Use this code to retrieve all the Index names for a given table Using SQL query: declare @tblName varchar(50);set @tblName = ‘GivenTable’;SELECT o.name as TableName, i.name AS IndexNameFROM sysobjects o,