Answer / Firdos Khan

nvarchar(max) is a data type used in SQL Server that allows storing variable length strings with a maximum size of 2^31 -1 (approximately 2 GB).

What is sql analyzer?

1 Answers  

---

How many indexes can be created on a table in sql?

1 Answers  

---

What is union, minus and interact commands?

1 Answers  

---

How many primary keys can a table have?

1 Answers  

---

how to include comments in sql statements? : Sql dba

1 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

What is a scalar value in sql?

1 Answers  

---

What is a left inner join?

1 Answers  

---

What is sqlerrm?

1 Answers  

---

how to get help information from the server? : Sql dba

1 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Explain aggregate functions are available there in sql?

1 Answers  

---