1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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





Question Posted / hassan.almohajjab


statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive De..

Answer / 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

More SQL Server Interview Questions

Explain about SQLOS?

0 Answers  

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

How can a database be repaired?

0 Answers  

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  




What is the purpose of indexing?

0 Answers  

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

In what three ways is the return statement used in a stored procedure?

0 Answers  

What are the pre-defined functions in the sql server?

0 Answers  

Why variables called the most powerful component of ssis?

0 Answers  

How to encrypt data between dialogs?

0 Answers  

What is autocommit mode in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories