Answer / Ravi Sanskrityayan

"To modify an existing stored procedure in MS SQL Server, you can use the ALTER PROCEDURE command. Here's an example:nnALTER PROCEDURE <procedure_name> AS...;..."

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

How to create indexed view?

1 Answers  

---

How many types of Cursor in SQL SERVER?

1 Answers  

---

How to get the query of a table in sql server?

1 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

1 Answers   Microsoft,

---

Define right outer join in sql server joins?

1 Answers  

---

What happens when converting big values to integers?

1 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

Explain the steps needed to create a scheduled job?

1 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

1 Answers  

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

Explain rdbms?

1 Answers  

---