What is the dbcc command and why is it used?

0 Answers  

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---

What is the bookmark lookup and rid lookup?

0 Answers  

---

---

What is a result set object returned by mssql_query()?

0 Answers  

---

What are the different types of replication you can set up in sql server?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

Explain the cursor lock types?

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  

---

List some case manipulation functions in sql?

0 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---