http://mohammadnazmul.blogspot.com/ https://nextleap.app/online-compiler/sql-programming
Sunday, September 7, 2025
SP
ALTER PROCEDURE [dbo].[PartNumberValidation_SELECT]
@PartNumber AS VARCHAR(80),
@PO AS VARCHAR(80) = NULL,
@Badge INT = NULL,
@OrderType AS VARCHAR(50) = NULL,
@Quantity INT = NULL,
@Result BIT output
AS
BEGIN
@PartNumber AS VARCHAR(80),
@PO AS VARCHAR(80) = NULL,
@Badge INT = NULL,
@OrderType AS VARCHAR(50) = NULL,
@Quantity INT = NULL,
@Result BIT output
AS
BEGIN
SET nocount ON;
IF @OrderType IS NULL
BEGIN
IF EXISTS ( 1 (/* condition */))
BEGIN
SET @Result = 1;
END
else
BEGIN
SET @Result = 0;
END
END
SET @Result = 1;
END
else
BEGIN
SET @Result = 0;
END
END
ELSE
BEGIN
IF EXISTS ( 1 )
BEGIN
SET @Result = 1;
END
else
BEGIN
-- Check the second condition
IF EXISTS ( 1 )
BEGIN
SET @Result = 1;
END
else
BEGIN
SET @Result = 0;
END
END
END
END
BEGIN
IF EXISTS ( 1 )
BEGIN
SET @Result = 1;
END
else
BEGIN
-- Check the second condition
IF EXISTS ( 1 )
BEGIN
SET @Result = 1;
END
else
BEGIN
SET @Result = 0;
END
END
END
END
Subscribe to:
Posts (Atom)
Important
https://www.youtube.com/watch?v=NWLyoCYEe0A
-
PTE Free materials হুমাইরা https://www.bdword.com/english-to-bengali-dictionary-learn-3000-plus-common-words-a-page-1 https://www.bdword....
-
Arabic letter Read QURAN https://www.youtube.com/watch?v=3GFWY88pKFE&list=PL4cBpGZ96Y1cfly16DUu_ZK85uKbILx8-&index=5 https:/...