How to write a stored procedure statement through the Query Analyzer

wumingzhe

I used it often, but I have n’t written a program in the past year

vgf10002

Text for display rules, default values, unencrypted stored procedures, user-defined functions, triggers, calculated columns, or views.

grammar
sp_helptext [@objname =] name
    [, [@columnname =] computed_column_name]

parameter
[@objname =] name

The name of the object will display the definition information of the object. The object must be in the current database. The data type of name is nvarchar (776), and there is no default value.

[@columnname =] computed_column_name

The name of the calculated column whose definition information is displayed. The table containing the column must be specified as objname, and the table must be in the current database. computed_column_name is sysname, there is no default value.

Return code value
0 (success) or 1 (failure)

cv4bf5d65fd

EXEC sp_helptext ‘stored procedure name’

我是杀人狂

select name as stored procedure name from sysobjects where xtype = 'P'
View all stored procedures and functions in the database
   use @database_name
   sp_stored_procedures

wumingzhe

Thank you enthusiastic friends