Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

IN Vs OR operator which is best to use sql server.

4 Answers  

---

What is scheduled job and how to create it?

0 Answers  

---

where can you add custom error messages to sql server? : Sql server administration

0 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

Is mysql the same as sql server?

0 Answers  

---

How do I make a resultset scrollable?

0 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

---

Explain important index characteristics?

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 are various ways to enhance the ssrs report?

0 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---