If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

What is a trigger?

7 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

Does group by or order by come first?

0 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

Explain the cursor lock types?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---

Explain error and transaction handling in sql server?

0 Answers  

---

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

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---