Hai,
For Example Below are two storeprocedures one returns resultset and
other not, how get this information through programmatically.
1)CREATE PROCEDURE dbo.UpdateCustomers
(
@CustomerID nchar(5),
@CompanyName nvarchar(40),
@ContactName nvarchar(30),
@City nvarchar(15),
@Phone nvarchar(24),
@Original_CustomerID nchar(5),
@Original_City nvarchar(15),
@Original_City1 nvarchar(15),
@Original_CompanyName nvarchar(40),
@Original_ContactName nvarchar(30),
@Original_ContactName1 nvarchar(30),
@Original_Phone nvarchar(24),
@Original_Phone1 nvarchar(24)
)
AS
SET NOCOUNT OFF;
UPDATE Customers SET CustomerID = @CustomerID, CompanyName =
@CompanyName, ContactName = @ContactName, City = @City, Phone = @Phone
WHERE (CustomerID = @Original_CustomerID) AND (City = @Original_City OR
@Original_City1 IS NULL AND City IS NULL) AND (CompanyName =
@Original_CompanyName) AND (ContactName = @Original_ContactName OR
@Original_ContactName1 IS NULL AND ContactName IS NULL) AND (Phone =
@Original_Phone OR @Original_Phone1 IS NULL AND Phone IS NULL)
GO
2)CREATE PROCEDURE dbo.AllCustomers
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
AS
Select * from Customers
RETURN 0
GO
Thanks in advance.
Thanks
--Gaj
