|
|
Posted by frien on 12/11/06 03:43
I want to create a stored procedure to find if the index exists if not
i have to create the index....i use following stored procedure....but
does'nt seem to be working.......but when i hard code the query it does
work... can u plz tell me were i am going wrong
CREATE PROCEDURE [dbo].[sd_find_create_ind]
@tblName varchar(255),
@colName varchar(255),
@indName varchar(255)
AS
declare @query varchar(1024)
select @query = 'IF indexproperty(object_id('+@tblName+'),
'+@indName+', ''IsClustered'') IS NULL
CREATE INDEX '+@indName+' ON '+@tblName+'('+@colName+')'
GO
thanks a lot
Navigation:
[Reply to this message]
|