T-SQL – Stored Procedures The MS SQL Server Stored procedure is used to save time to write code again and again by storing the same in database and also get the required output by passing parameters. Syntax Following is the basic syntax of Stored procedure creation. Create procedure <procedure_Name> As Begin <SQL Statement> End Go […]
Category Archives: t Sql
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 […]
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 […]