SQL Simplified

To find the definition of a View/ Trigger/ User Defined Function/ Stored Procedure



Method 1:




Method 2:





Method 3:

sp_helptext <storedprocedurename>
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Posts (Atom)

SQL Server

  • Difference between ISNULL and COALESCE
  • To find the definition of a View/ Trigger/ User De...
  • To find the size of all the tables in a database
  • To Count the Number of Rows from all the tables in the database
  • Query to find the size consumed by a table in the ...
  • Query to find view the contents of the Globally de...
  • Accessing the Data of a global temp table exis...
  • SELECT * FROM SYS.data SELECT TBL.name [TABLE NAME...
  • Fetch number from Alpha numeric string
  • Script to replace a particular string in all the S...
By : Avinash Anad. Simple theme. Powered by Blogger.