Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3294 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanthi
create procedure sp_givesomename(@Id_Receive varchar(50))
as
select Id_Receive+'_'+Description_Receive+'debit account
credit account balance:'
+Amount_Receive from dbo.Receive where
Id_Receive=@Id_Receive
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what are the steps to process a single select statement?
Explain the usage of floor function in sql server.
What is the purpose of forms?
What do you understand by physical_only option in dbcc checkdb?
Can another user execute your local temporary stored procedures?
How do you start single user mode in clustered installations?
What is the server name for sql management studio?
Do you know how to store and query spatial data?
Can you use order by when defining a view?
What is extent? Types of extents?
How do I view a script in sql server?
Explain what is the difference between union and union all?
How many types of schemas are there?
What are the requirements on sql server network connections?
How do you create a clustered index?
