Answer / Pintu Kumar

Changing a column from CHAR to NCHAR in SQL Server will have a few implications. First, the new NCHAR column will store Unicode characters rather than ANSI characters like the original CHAR column. Second, if no explicit length is specified when altering the column, the default length (1) will be used for each character stored. This could result in increased storage requirements due to the larger size of each Unicode character compared to an ANSI character.

What guidelines should be followed to help minimize deadlocks?

1 Answers  

---

What are character string data types in ms sql server?

1 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

1 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1 Answers   Genpact,

---

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

---

Can you insert NULL in unique column?

1 Answers   MCN Solutions,

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

Why the trigger fires multiple times in single login?

1 Answers  

---

Can truncate be rolled back?

1 Answers  

---

What is the difference between implicit and explicit transaction?

1 Answers   Beahead Private Limited,

---

Tell me what are the essential components of sql server service broker?

1 Answers  

---

Explain datetime2 data type in sal server 2008?

1 Answers  

---