Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement

Database development, Languages & Coding, Statements, T-SQL

In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL...
Read More

Basic and Complex Uses of Not Equal Comparison Operator in T-SQL

Languages & Coding, T-SQL

This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic to slightly complicated SQL scripting...
Read More

T-SQL SET Operators Part 1: UNION and UNION ALL

Languages & Coding, T-SQL • One Comment

In SQL Server, we can combine the same type of data from multiple tables using SET operators. After combining multiple SQL statements, it...
Read More

How to use SQL Cursors for Special Purposes

Database administration, Languages & Coding, T-SQL

This article describes SQL cursors and how to use them for some special purposes. It highlights the...
Read More

Concatenation in Transact-SQL

Languages & Coding, Statements, T-SQL

Introduction Assuming you maintain a table containing customer data, and your boss asks you to send him the current list of customers and...
Read More

Transferring Jobs and Schedules between Instances using T-SQL

Languages & Coding, T-SQL

Introduction Quite often, there is a need to transfer Agent jobs to a different instance of MS SQL Server. Restoring a msdb database will...
Read More

Basics of Running T-SQL Statements from Command Line using SQLCMD

T-SQL, Tools & technologies, Utilities & Extensions

This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands...
Read More

How to Write T-SQL Queries Like a Pro

Languages & Coding, T-SQL

The skills of writing different types of SQL Server queries require you to have good knowledge in the SQL Server T-SQL language. T-SQL...
Read More

Traditional and Natively Compiled Scalar-Valued User-Defined Functions

Languages & Coding, T-SQL

In the software programming world, there are several approaches used by developers that help them with effortless software development....
Read More

T-SQL BEST Practices

Languages & Coding, T-SQL • 3 Comments

In this article, we will discover some best practices of T-SQL queries. Badly written queries can...
Read More
Close