Answer / rohit bhosale

Sql SErver 2008 exist with a highly available concepts that
are helpful to provide data security or protection,to
improve performance while SQL Server 2005 is lack of these
concepts hence We all are preferable to use 2008.

Answer / dinesh rathod

1, XML datatype is introduced. XML datatype is used. 2, Can not encrypt the entire database.

How to create a local temporary stored procedure?

0 Answers  

---

What is nonclustered index with included columns ?

0 Answers  

---

One table how may column and Primary key

3 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

What is data source object?

0 Answers  

---

Explain transaction server consistency?

0 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

What is scalar user-defined function?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---