Tag: t-sql

How to Rename a Table Name in SQL Server

Database development, SSMS, Stored Procedures, Tables

One of the most critical database administrator’s duties is managing database objects. For...
Read More

Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function

Database development, Statements, Work with data

Today’s code editors and word processors come with a search and replace feature. It is helpful when you need to change a word or a...
Read More

MySQL Insert Command vs T-SQL Query Syntax with Examples

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

Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp,...
Read More

SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table

Database development, Statements, Tables

The right application of the DELETE statement for data removal is crucial, and it involves lots of...
Read More

Difference Between DELETE and TRUNCATE Table in SQL Server

Database development, Statements, Tables

Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
Read More

SQL UNION Cheat Sheet with 10 Easy and Useful Tips

Database development, Statements

Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into a standstill. Or a report that’s been...
Read More

Create a Database in SQL Server Using SQL Server Management Studio (SSMS)

SSMS, Tools & technologies

This article briefly explains creating a new database with the New Database wizard of SQL Server...
Read More

Fundamentals of Managing Datafiles in SQL Server

Database administration, Work with data

Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
Read More

Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables

Database development, SQL Server, Statements, Tables

INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
Read More

Manage MDF Files in SQL Server 2019

Database administration, Work with data

An SQL Server database contains primary data files, secondary data files (optional), and...
Read More
Close