where are stored procedures stored.
-
Where are Stored Procedure stores in MySQL or any other database e.g. SQL Server etc ..... Further explanation of my question, Such that if i created a database then i know all my data is in this created database ..... but if i talk about creating/using stored procedures then were are they stored. I.ve searched some example and tutorials for stored procedure ... but i didn't found aobut it. THANKS
-
Where are Stored Procedure stores in MySQL or any other database e.g. SQL Server etc ..... Further explanation of my question, Such that if i created a database then i know all my data is in this created database ..... but if i talk about creating/using stored procedures then were are they stored. I.ve searched some example and tutorials for stored procedure ... but i didn't found aobut it. THANKS
khurram_shahzad wrote:
Such that if i created a database then i know all my data is in this created database ..... but if i talk about creating/using stored procedures then were are they stored
They are stored in hidden table of same database. You could access it using following.
select * from sys.sql_modules where object_id=object_id('Name_of_your_sp')
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator.