What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What functions can a view be used to performed?

0 Answers  

---

how many triggers you can have on a table? : Sql server database administration

0 Answers  

---

What is a non-clustered index?

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

Explain in brief about Microsoft SQL server?

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

How to enter unicode character string literals in ms sql server?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

What is bit data type?

0 Answers  

---