Browse By

Tag Archives: Store Procedure

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