Browse By

Monthly Archives: March 2014

SQL - UDF and Trigger

Basic SQL for Testers : UDF & Triggers

1. User Defined Functions There are two types of User-Defined functions in SQL Server and they are Scalar, and Table-Valued. 1.1 Scalar Function A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These


Basic SQL for Testers : Store Procedures

1. Some Facts about Store Procedure If a repetitive T-SQL task has to be executed within an application, then the best repository for it is a program called a Stored procedure, stored in SQL Server. Storing the code inside the SQL Server object gives us

SQL Basics for Testers

Basic SQL for Testers : SET Operators

SET operators are mainly used to combine the same type of data from two or more tables. Although more than one select statement will then be present, only one result set is returned. Rules on Set Operations: 1. The result sets of all queries must

SQL Basics for Testers

Basic SQL for Testers : SQL JOIN

1. What is SQL Joins? An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. 2. SQL Inner Join The INNER JOIN keyword selects all rows from both tables as long as there is a match