How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 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 can you attach more than 20 ldf files in sql server

0 Answers   IBM,

---

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---

Can we use where and having clause together?

0 Answers  

---

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

Define views.

0 Answers  

---

What does executeupdate return?

0 Answers  

---

What is pessimistic concurrency?

0 Answers  

---

What do you understand by intent locks?

0 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---