Two types of merge tables 1. INSERTED 2. DELETED When we insert the record into the table, the magic table " INSERTED...
Read More
DATEFROMPARTS Function
Description: The DATEFROMPARTS function returns a date value for the specified year, month, and day. The syntax of the DATEFROMPARTS...
Read More
returns a value out of a list based on its index number using sql server
Choose() Function This function returns a value out of a list based on its index number. You can think of it as an array kind of thing. T...
Read More
IF condition in Sql Server
DECLARE @X INT; SET @X=50; DECLARE @Y INT; SET @Y=60; ...
Read More
Subscribe to:
Posts (Atom)