Mohammad Chowdhury
http://mohammadnazmul.blogspot.com/ https://nextleap.app/online-compiler/sql-programming
Sunday, September 7, 2025
SP
@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
SET @Result = 1;
END
else
BEGIN
SET @Result = 0;
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
Tuesday, August 5, 2025
Saturday, July 26, 2025
SQL
Saturday, June 21, 2025
TWIN MODULE - Dyncraft
eBom vs mBom
SELECT distinct * FROM [DataStage].[dbo].[CUMEBOM_LOADING] as CL where CL.LineSeqNbr='T0890F0' and CL.ChassisNbr='790040';
select * from EWI_DataWarehouse.dbo.OpenJITs as OJT where OJT.LineSeqNbr ='T0890F0';
select * from EWI_DataWarehouse.dbo.OpenJITs as OJT where OJT.ItemID ='M86-6301-127106';
SignalR
--ALTER DATABASE SignalR SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;
SELECT is_broker_enabled FROM sys.databases WHERE name = 'SignalR';
Persistent Connection:
This means that the connection between the client (such as a web browser) and the server stays open and active over a period of time, rather than opening and closing repeatedly for each communication.
SignalR leverages WebSockets or other transport alternatives:
SignalR is a real-time communication library for web applications. It primarily uses WebSockets, which is a modern protocol that allows two-way communication between the client and server over a single, long-lived connection
SignalR ensures that the client and server remain continuously connected and can send messages to each other in real-time. This is useful for applications like chat apps, live notifications, gaming, or any scenario requiring immediate updates without the need to refresh the page
https://assemblytools.na.panasonic.com/assembly-tools/accessories/controllers
Tuesday, April 15, 2025
Wednesday, March 5, 2025
Driving
https://youtube.com/shorts/5Ac2qZHrApU?si=_X-G7pJFHiZoD-s7
https://www.youtube.com/watch?v=f6pSsex87oU
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:/...