Answer / sumesh.tc

SELECT syscomments.text AS text
FROM sysobjects INNER JOIN
syscomments ON sysobjects.id =
syscomments.id where sysobjects.name=(stored procedure name)

Answer / ramakrishna

select text from sysindexes

How to change the data type of an existing column with "alter table" statements in ms sql server?

1 Answers  

---

What is repeatable read?

1 Answers  

---

what is an index? : Sql server database administration

1 Answers  

---

Get Current System Date Time

2 Answers  

---

What are the character string functions supported by sql server 2005?

1 Answers  

---

What is the difference between functions and scalar functions?

1 Answers   EXL,

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

Differentiate between delete and truncate.

1 Answers  

---