Answer / Pajkaj Kumar

"To enter Unicode character string literals in MS SQL Server, you can use the N prefix. For example:nnSELECT N'Unicode String';"

How to see the event list of an existing trigger using sys.trigger_events?

1 Answers  

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1 Answers  

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What is a mutating table error and how can you get around it?

1 Answers  

---

What are the difference between clustered and a non-clustered index?

1 Answers  

---

What is a filestream?

1 Answers  

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

Explain where clause?

1 Answers  

---

What do you mean by acid?

1 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 Answers  

---

Why use “nolock” in sql server?

1 Answers  

---