USING THE T-SQL MERGE STATEMENT
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability to perform INSERTs, UPDATEs and
Menu
Technology News TH
THE ONE MILLION ROW T-SQL TEST HARNESS
So far in our blogs, we have talked a bit about performance, so today we’re going to show you a way you can confirm without
MANIPULATING DATES AND TIMES IN T-SQL
In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions. The full list of these
CALENDAR TABLES IN T-SQL
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of querying flexibility if you have one
TALLY TABLES IN T-SQL
The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a T-SQL WHILE loop? How about
THE T-SQL ROW_NUMBER() WINDOW FUNCTION
If you learn one new T-SQL (i.e., Microsoft SQL Server) concept today it should be ROW_NUMBER(). Introduced in SQL 2005, this function is one of
NMAP – BASIC INTRODUCTION AND COMMANDS
Nmap – Network Mapper is a free and an open source application for network discovery, security auditing application. This application is available for windows and
EQUIVALENCE CLASS PARTITIONING
Equivalence class partitioning or EQP is the technique of blackbox software testing method. In this technique tester separates data in two distinct type Valid data
BOUNDARY VALUE ANALYSIS
In a blackbox testing method boundary value analysis is the most effective software testing technique. In this method tester tries to test the application object
REDUCE THE NUMBER OF BUGS IN PRODUCTION AND TESTING ENVIRONMENT – LET THE PROGRAMMERS TEST THEIR OWN
Due to smaller release cycles, frequent changes in requirements and to meet the deadline of project release many times we need to release product untested