Answer / priya reddy

user_constraints table will contain the information on
constraints on all the tables created.

Answer / srao

select * from sysindexes

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

What is transaction ? Give me one example.

11 Answers   Melstar, Wipro,

---

How do I save a stored procedure in sql server?

0 Answers  

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

What is difference between line feed ( ) and carriage return ( )?

0 Answers  

---

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

What is data compression?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---