How can you get @@error and @@rowcount at the same time?

9 Answers  

---

Can we use custom code in ssrs?

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  

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

What are the 3 types of schema?

0 Answers  

---

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What is the partitioning method?

0 Answers  

---

How can sql server instances be hidden?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

---

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

---