adspace


How do I view stored procedures?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


Does group by remove duplicates?

1122


how to start mysql server? : Sql dba

1279


what is schema? : Sql dba

1165


Can we rollback truncate?

1086


Is primary key always clustered index?

1101


what are the advantages of sql ? : Sql dba

1154


what are aggregate and scalar functions? : Sql dba

1143


What is your daily office routine?

2353


how many tables will create when we create table, what are they? : Sql dba

1157


what are all the common sql function? : Sql dba

1143


Do we need to rebuild index after truncate?

1156


What is the current version of postgresql?

1189


what is bcp? When does it used? : Sql dba

1065


what is dbms? : Sql dba

1072