Tag: t-sql statements

Bulk Insert Data Files Into SQL Server

Database administration, Work with data

According to Wikipedia, the bulk insert is a process or method provided by a database management...
Read More

SQL Server Bulk Insert – Part 1

Database administration

According to Wikipedia, ”A Bulk insert is a process or method provided by a database management system to load multiple rows of data...
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 directly from the command prompt without the...
Read More

MERGE: Updating Source and Target Tables Located on Separate Servers

Database development, Statements, Tables

What is the MERGE statement? Using the MERGE statement, we can change data in a target table based...
Read More

Unleash the Power of SQL Pivot and Unpivot: A Complete Guide to Data Transposing Techniques

Database development, Statements

Data manipulation is an essential skill for anyone working with SQL databases. It allows you to transform and analyze data, making it more...
Read More

Grouping Data using the OVER and PARTITION BY Functions

Database administration, Work with data • One Comment

The OVER and PARTITION BY functions are both functions used to portion a results set according to specified criteria. This article explains...
Read More

Methods to Rank Rows in SQL Server: ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE()

Database development, Statements

SQL Server provides us with a number of window functions that help us to perform calculations...
Read More