Answer / Prawin Kumar

In SQL Server, determining the largest component inside a field depends on the data type. For numeric fields like integers or floating-point numbers, the largest value would be the maximum possible value for that specific data type (e.g., 2147483647 for an integer). For string fields, the largest component is typically considered to be the longest string in terms of characters.

How do you size a resultset?

1 Answers  

---

What is the maximum row of a size?

1 Answers  

---

What is the simplest way to create a new database in ms sql server?

1 Answers  

---

What is a field name?

1 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

1 Answers  

---

Explain steps of normalization?

1 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is scalar user-defined function?

1 Answers  

---

What are the types of user defined functions in sql server?

1 Answers  

---

What are system databases into sql server (2005/2008)?

1 Answers  

---

What is the use of RDBMS?

1 Answers   Wipro,

---

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  

---