please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

what is dbcc? : Sql server database administration

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  

---

What are the new features in sql server 2016?

0 Answers  

---

---

Explain about nested stored procedure?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

When you should use a low fill factor?

0 Answers  

---

How many columns can we include on clustered index ?

0 Answers  

---

what are the advanced features in sql 2008?

2 Answers   Wipro,

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---