Suppose we want to get the name of the parameter for the Store Procedure
Course_Insert_sp then folllowing needs to be executed.
SELECT * FROM sys.parameters D INNER JOIN Sys.Objects O ON O.object_id=D.object_id WHERE O.name='Course_Insert_sp'
Microsoft Technologies, ASP.NET, C#, VB.NET, SQL Server, JavaScript, XML, XSLT, Import/Export Excel and csv files, Payment Gateway Integration, Ajax.
SELECT * FROM sys.parameters D INNER JOIN Sys.Objects O ON O.object_id=D.object_id WHERE O.name='Course_Insert_sp'
0 comments:
Post a Comment