Explain about the command-line tool SQLCMD?

0 Answers  

---

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

Which tcp/ip port does the sql server run on? How can it be changed?

0 Answers  

---

What do you mean by an execution plan? Why is it used?

0 Answers  

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

How to sort the query output with order by clauses in ms 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  

---