Answer / Shabnam Parween

You can use the CONVERT() function in MS SQL Server to convert numeric expression data types. The basic syntax is: CONVERT(data_type, expression [, length ] [, style ]). For example, to convert a decimal value to float, you can use: CONVERT(FLOAT, DecimalValue)

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1 Answers  

---

Mention the differences between having and where clause.

1 Answers  

---

What is 1nf 2nf?

1 Answers  

---

What is normalization? Describe its different types.

1 Answers   Wipro,

---

Does table partitioning improve performance?

1 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1 Answers  

---

What is nolock hint in sql server 2008

1 Answers   HCL,

---

Explain following error properties?

1 Answers  

---

What is public role in sql server?

1 Answers  

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

What are different types of views?

1 Answers  

---