An overview of SQL system keywords

Create proc Proc_b  as  SELECT * from   [zkbtest].[ DBO]. [T_ZKB]  EXEC sp_helptext proc_b    Select  * from sys.sql_modules where object_id= object_id (' Proc_b ')--inside the object_ ID to learn about

　　

create proc Proc_b  as SELECT TOP [ID]      , [Name]      , [ZKB] from  [zkbtest].[ DBO]. [T_ZKB]

Spicy All levels----pictures do not come to the company to upload photos tomorrow

If you see a view or stored procedure, 1:30 will not find him there, then you just use the following SQL is a built-in definition method

1, sp_helptext 2, Sys.modules

An overview of SQL system keywords