Displays the definition of a user-defined rule, default, unencrypted Transact-SQL stored procedure, user-defined Transact-SQL function, trigger, computed column, CHECK constraint, view, or system object such as a system stored procedure.
-- View
use AdventureWorksDW2008
sp_helptext vDMPrep
-- Stored Proceudre
use AdventureWorks
sp_helptext uspGetBillOfMaterials
--Object_definition will not do this, but sp_help
--how does sp_helptext work?
sp_helptext 'sp_helptext'
No comments:
Post a Comment