What are the new scripting capabilities of ssms? : sql server management studio
- 0 Answers
- 722 Views
- I also Faced
- E-Mail Answers
Mention the 3 ways to get a count of the number of records in a table.
What is nested transaction?
What is partitioned view?
Explain following error properties?
What is resource governor?
What is the command to change the recovery model?
What is normalization in Database ?
What is the difference between lock, block and deadlock? : sql server database administration
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
What is the difference between HAVING clause and the WHERE clause?
How do I clean up sql server transaction log?
Do you know what is difference between stored procedure and user defined function?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
