Answer / subbu

User-defined data types can be used when several tables
must store the same type of data in a column and you must
ensure that these columns have exactly the same data type,
length, and nullability.

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  

---

What are approximate numeric data types in ms sql server?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

Define outer join?

0 Answers  

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

---

Explain powershell included in sql server 2008?

0 Answers  

---

What is difference between views and stored procedures?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

What are the main control-of-flow T-SQL constructs?

1 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

---

How to use clusters?

0 Answers   Amdocs,

---