Tag: t-sql

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching...
Read More

Overview of T-SQL PRINT Statement

Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
Read More

T-SQL Stuff Command

Database development, Statements

The main idea around the SQL Server function called STUFF is concatenating multiple columns into a single column with more flexibility than...
Read More

Managing your MS SQL Replication

Database administation, Transaction Log

Replication is one of the oldest technologies on MS SQL Server, loved by every database...
Read More

Clustered and Non Clustered Index: 7 Top Points Explained

Database development, Indexes • One Comment

Indexes are speed-boosters in SQL databases. They can be clustered or non-clustered. But what does it mean and where should you apply...
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

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

Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
Read More

TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers

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

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are...
Read More

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 instance, the application logic changes,...
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, Statements, T-SQL

Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If...
Read More
Close