Understanding Data Types and Variables in MSSQL vs PostgreSQL

DECLARE @Name VARCHAR(100);
SET @Name = 'Himanshu';

-- OR
SELECT @Name = 'Himanshu';

-- Start an anonymous code block using DO and dollar-quoting $$
DO $$
-- Declare the variable section
DECLARE
    -- Declare a VARCHAR variable named 'name' and assign it a value
    name VARCHAR := 'Himanshu';
BEGIN
    -- Display the value of the variable using RAISE NOTICE (used for debugging/output)
    RAISE NOTICE 'Name is %', name;

    -- You can also perform other logic here (loops, conditions, etc.)
END $$;
-- End of the anonymous DO block

SHOW server_version;
SELECT current_setting('server_version');
SET work_mem = '32MB';

SET my.custom_var = 'hello'; -- needs custom configuration prefix

DO $$
DECLARE
    counter INT := 1;
BEGIN
    WHILE counter <= 3 LOOP
        RAISE NOTICE 'Counter = %', counter;
        counter := counter + 1;
    END LOOP;
END $$;

INSERT INTO Employees (Name) VALUES ('John');
SELECT SCOPE_IDENTITY() AS LastID;

INSERT INTO Employees (Name) VALUES ('John') RETURNING id;