Why SQL Agent is used?

0 Answers   Abacus,

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

What are constraints in microsoft 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 are explicit and implicit transactions?

4 Answers   BirlaSoft,

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

What are xml indexes?

0 Answers  

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What is a function? Give some example?

3 Answers  

---