Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288) 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 3284Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
2 5056can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
1 9147what is package configuration variable?How to change file name in folder dynamically?Plz help me
1 3280
How do I setup mysql?
Where is pgadmin installed?
How to Join tables on common columns.
Which are the different character-manipulation functions in sql?
What command would you use to create an index?
How do you create a database in access?
Do you have any idea about the tcl commands?
What is the difference between execution of triggers and stored procedures?
What is 3nf normalization form?
What is the difference between delete and truncate statements?
List the various privileges that a user can grant to another user?
how to write date and time literals? : Sql dba
What is the first step in creating a database?
What is the full form of dba?
How do you identify a primary key?