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 restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---

Does partitioning help performance?

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

What is the difference between value type and reference type?

0 Answers  

---

How adventureworkslt tables are related?

0 Answers  

---

What is faster join or union?

0 Answers  

---

Explain the different types of backups available in sql server? : sql server database administration

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

What are the types of sql server?

0 Answers  

---