IT Questions and Answers :)

Friday, August 16, 2019

In T-SQL, very rarely would you need to use the following:

In T-SQL, very rarely would you need to use the following:

  • CTE


Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE or MERGE statement. This clause can also be used in a CREATE VIEW statement as part of its defining SELECT statement. A common table expression can include references to itself. This is referred to as a recursive common table expression.

Transact-SQL Syntax Conventions


[ WITH <common_table_expression> [ ,...n ] ]  
    expression_name [ ( column_name [ ,...n ] ) ]  
    ( CTE_query_definition ) 

T-SQL stands for Transact-SQL, and is Sybase & Microsoft’s proprietary extension.
T-SQL is a programming language and very similar to PL/SQL (in Oracle), one can create T-SQL units such as SQL Scripts, Stored Procedures, Functions, Types, Triggers, etc.
SQL DBA is entirely different track and requires different skills, and have altogether different carrier path. It deals with non-programming stuff usually, like installing SQL Server, maintaining databases, backup/restore, user security, etc, and much more stuff.
Thus you won't get more people/resources with both the skills.
For more details on T-SQL, SQL and database languages and tools check this blog post: What is SQL, PL/SQL, T-SQL and difference between them



Post a Comment

Popular Posts