How do I view stored procedures?



How do I view stored procedures?..

Answer / Jayanti Sahu

To view stored procedures in SQL Server, you can use the sp_helptext system stored procedure or the sys.sql_modules catalog view.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can we call a function containing dml statements in a select query?

1 Answers  


What is the use of sql trace?

1 Answers  


What is t sql in sql server?

1 Answers  


if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  


Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  


Can there be 2 primary keys in a table?

1 Answers  


Which one is faster ienumerable or iqueryable?

1 Answers  


i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,


i have some prob lem to tell me about my self in interview first round ...

1 Answers  


What is a system versioned table?

1 Answers  


Name three sql operations that perform a sort.

1 Answers  


How to connect a sql*plus session to an oracle server?

1 Answers  


Categories