1st Day as SQL Web Tutor

My aim to create this blog is to write all such tricks and tips in SQL queries which will be helpful to my friends all over the world.

I want to share my experience about the SQL and hence i am too excited to start with....

Hope you all take me further over the web with my genuine intention to help you out with enjoyment of the technology......

Dynamic query to get all columns value from a table except the primary key column

-------------------------------------------------------------------------------

declare @qry nVarchar(4000)

@tblName Varchar(100)

@i int

@cnt int

declare @colNames nvarchar(4000)

set @colNames = ''set @qry = 'select name from syscolumns where id = (select id from sysobjects where name ='+ @tblName

create table #tmp(ID int identity(1,1), ColName Varchar(60))

insert into #tmp(ColName)

exec (@qry)

select @cnt = count(id) from #tmp

while (@i <= @cnt)

begin

select ColName from #tmp where id = @i

set @colNames = @colNames + (select ColName from #tmp where id = @i)

set @colNames = @colNames + ','

set @i = @i + 1

end

set @colNames = substring(@colNames, 1, len(@colNames)-1)

set @qry = ''set @qry = 'select ' + @colNames+' from ' + @tblName

exec (@qry)