How to create stored procedures with parameters in ms sql server?

0 Answers  

---

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

---

What is the difference between deallocate cursor and close cursor?

0 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

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  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What is a hint?

0 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

Explain what is the main purpose of having conversation group?

0 Answers  

---

what is normalization? : Sql server database administration

0 Answers  

---