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')

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

How do I open port 1433?

0 Answers  

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

What is normalization in Database ?

4 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

Explain what is the function of sql server agent windows service?

0 Answers  

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---