T-SQL – Transactions A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program. A transaction is the propagation of one or more changes […]

T-SQL – Functions MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions − − The SQL Server COUNT aggregate function is used to count the number of rows in a database table. − The SQL Server MAX aggregate function […]

T-SQL – Joining Tables The MS SQL Server Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each. Consider the following two tables, (a) CUSTOMERS table is as follows − ID NAME AGE […]