to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

What is difference between equi join and inner join?

0 Answers  

---

Does table partitioning improve performance?

0 Answers  

---

How to Update from select query in sql server?

0 Answers  

---

what is a cursor and what is its use?

2 Answers   L&T,

---

How to modify an existing stored procedure in ms sql server?

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  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

How to disable stored procedure sql server?

0 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

What is a trigger and its types?

0 Answers  

---