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
supasiri.s
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
MAKE IT WORK, MAKE IT FAST, MAKE IT PRETTY
When I first heard this, it struck me as being a remarkably concise wisdom applicable to virtually any programming task. The entire quotation is actually:
CHOOSING THE RIGHT CMS
When it comes to building websites and managing content there are many platforms to choose from. At Aware we use several, both open source and
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
COMMON TABLE EXPRESSIONS IN SQL
In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE). CTEs share similarities with VIEWS and derived tables, but are really not the same
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
What the CEO is Reading – It’s time to look at the positives
A recent study published in the Harvard Business Review called the “three good things” intervention, demonstrates that thinking about positive events in a systematic way can be healthy and suggests,
EXECUTING COMMANDS ON WINDOWS POWERSHELL ISE
To get the list of commands starting with “Get” on windows PowerShell ISE following command can be executed. Here “*” works as a wildcard character.