IF OBJECTPROPERTY(object_id('[dbo].[Prc_Save]'), N'IsProcedure') = 1
DROP PROCEDURE [dbo].[Prc_Save]
GO
CREATE PROCEDURE [dbo].[Prc_Save]
(
@Id INT,
@ProductId INT
)
AS BEGIN
select * from dilip where Id=@Id AND IsActive=1
select * from dilip WHERE ProductId=@ProductId AND IsActive=1
END
GO
If StoreProcedure Exist then drop then Create
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.