Answer / Tarakeshwar Kumar Puri

The ISNULL function in SQL Server returns a specified value if an expression is null, otherwise it returns the original expression. Here is an example: SELECT ISNULL(ColumnA, 'DefaultValue') FROM YourTableName;

What is the purpose of floor function?

1 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

1 Answers  

---

Explain ms sql server reporting services vs crystal reports?

1 Answers  

---

What is key set driven?

1 Answers  

---

Why SQL Agent is used?

1 Answers   Abacus,

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1 Answers  

---

What is a trigger in sql server?

1 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

1 Answers   IBM,

---

Explain error handling in ssis?

1 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1 Answers  

---

Do you know what are various aggregate functions that are available?

1 Answers  

---

what is a cursor and what is its use?

2 Answers   L&T,

---