Wednesday 7 May 2014

Sql Server

To Know About the List of Procedure in Database

select * from sys.procedures

To Know About the List of Trigger in Database
select * from sys.triggers

To Know About the List of Tables in Database
select * from sys.tables

To Know about the List of Procedure
select * from INFORMATION_SCHEMA.ROUTINES where Routine_Type='Procedure'


To Know about the List of Functions
select * from INFORMATION_SCHEMA.ROUTINES where Routine_Type='Function'

http://www.mpez.co.in/Discom_Batch/rest/getETransactionCount/ETAAL_JBL/JBL@123/08-05-2014

http://164.100.72.97/webservice.asmx?wsdl