Hi

Magic Tables and types of magic tables

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