Browse By

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


Usability Testing – Few points to look at

1. The mobile application layout should be rearranged for better user Experience, when the user changes the screen orientation to landscape or portrait. 2. Utilizing the display area in the device for the links, menus, images, etc. should be well distant from the edges of

No Thumbnail

Types of Testing for Mobile Application

Usability This includes text visibility, navigation between screens, response from interaction with system. Compatibility testing This entails validating the application for different mobile devices, OS versions, screen sizes, and resolutions as per requirement Interface Testing This covers validation of each screen, buttons, text inputs, navigation