Answer Posted / ram

select * from tablename
select distinct * from tablename
above two select statements give same output with all
column name and also data
if we want only column name & its details(datatype,sizre)
use

select * from
information_schema.columns where table_name='EMP1'
(or)
select distinct * from
information_schema.columns where table_name='EMP1'

(Here Table name mustbe in single quotes and also capital
letters only)
here also both select statements output is same

How to get the query of a table in sql server?

877

---

Which are the important points to note when multilanguage data is stored in a table?

971

---

Which tcl commands are available on the sql server?

1059

---

How to insert stored procedure result into temporary table?

1003

---

Do you know spatial data types - geometry and geography in sql server 2008?

1003

---

Does partitioning improve performance?

949

---

How to create an inline table-valued function?

948

---

Explain the dirty pages?

982

---

How to add an address record into adventureworkslt?

970

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1051

---

What is mapping schema?

1010

---

What is a virtual table in sql?

976

---

Write the syntax for stuff function in an sql server?

1010

---

What is the difference between upgrade and migration in sql server?

1059

---

What is database replication?

1115

---