Answer / k m rajesh

Declare @ColumnName Varchar(50)
Select @ColumnName = Name From syscolumns Where id = object_id(Table_Name) and ColID = (Select Count(name)-1 from SysColumns Where id = object_id(Table_Name))

Answer / rajesh ranjan

Declare @ColumnName varchar(50)
select @ColumnName=Name from syscolumns where id=object_id
(Table_Name) and colid=1 --2 for second Column, 3 for third
exec ('select '+@ColumnName+' from Table_Name')

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

Can we call future method from trigger?

0 Answers  

---

What is difference between equi join and natural join?

0 Answers  

---

How to create function with parameter in sql server?

0 Answers  

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

---

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

What is inner join? Explain with an example?

0 Answers  

---

How do I perform an unattended install of sql server 2000?

0 Answers  

---

What is 2nf normalization form?

0 Answers  

---

Define left outer join?

0 Answers  

---

What is 3nf normalization form?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---