What is set nocount on and what is set nocount off?

0 Answers  

---

How many types of stored procedures are there in sql server?

0 Answers  

---

Explain a checkpoint?

0 Answers  

---

What is public role in sql server?

0 Answers  

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

What is the purpose of floor function?

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  

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

Can I delete event logs?

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---

How to modify the underlying query of an existing view?

0 Answers  

---

How to find 6th highest salary from Employee table ?

10 Answers  

---