T-SQL Interview Questions
Here are some T-SQL interview questions and answers: Q: What is T-SQL? A: T-SQL (Transact-SQL) is a programming language used to manage...
top of page
Learn T-SQL
mike92980
- Mar 18
- 7 min
Looping In T-SQL
In T-SQL, there is no specific "for each" statement, but there are several ways to iterate over a set of rows in a table or result set....
mike92980
- Mar 18
- 6 min
Aliasing In T-SQL
If you're a DBA working with T-SQL, aliasing can be an invaluable tool for simplifying your queries. Aliasing is the process of assigning...
mike92980
- Mar 18
- 9 min
SQL Server Data Types
SQL Server Data Types As a DBA or IT Pro, it's important to understand the sql server data types. Knowing which type of data is most...
mike92980
- Mar 18
- 6 min
Introduction To T-SQL in SQL Server
Are you looking to learn about T-SQL in SQL Server? Do you feel lost and overwhelmed when jumping into a new programming language? You’re...
mike92980
- Mar 18
- 11 min
SQL Server Compatibility Levels Vs Setting Up A Contained Database.
Whether you are a small business owner or work at an enterprise organization, effective management of your SQL Server is integral for...
mike92980
- Mar 18
- 8 min
SQL GROUP BY to Summarize and Rollup Query Results
What Is “Grouping” In SQL, And Why Is It Needed? Grouping in SQL group together is a powerful concept that allows us to group rows of...
mike92980
- Mar 17
- 4 min
SQL Drop Table Examples with T-SQL
Introduction to SQL DROP TABLE statement Are you a SQL Server DBA struggling with the Drop Table command? Did you know that T-SQL offers...
mike92980
- Mar 16
- 6 min
SQL DELETE - Deleting Data In A Table Or Multiple Tables
Overview of the T-SQL Delete Command With Examples
mike92980
- Mar 2
- 5 min
SQL GROUP BY and HAVING Clause with Examples
This is post is about GROUP BY clause this SQL divides the rows returned by a query into groups, based on the values in one or more columns
mike92980
- Feb 19
- 8 min
SQL UPDATE Statement - Updating Data in a Table
In this article, we'll give you a brief introduction to the UPDATE command in Microsoft SQL Server. We'll cover what it is, how to use it.
mike92980
- Feb 18
- 7 min
SQL Server - SQL CASE statement: What is it and what are the best ways to use it?
An introduction to the UPDATE query in Microsoft SQL Server. Also use the CASE statement with the UPDATE query to update your data.
mike92980
- Feb 18
- 13 min
SQL Server Create Table Statement
Learn how to create a table in SQL Server with primary keys, check constrains and nulls
mike92980
- Feb 17
- 3 min
SQL Server Transact SQL - Where In
SQL Server Transact SQL - Where In Introduction To SQL Server Where In Clause In this syntax, the column_name is the name of the column...
mike92980
- Feb 15
- 7 min
SQL COALESCE Function: Handling NULL Values Effectively
SQL (Structured Query Language) code and demonstrates coalesce functionality that mirrors real-life situations.
mike92980
- Feb 15
- 14 min
Understanding and Implementing Triggers in SQL Server
What Is A Trigger In T SQL Triggers in SQL Server are used to automate tasks whenever a change is made to the database. This allows for...
mike92980
- Feb 2
- 6 min
Comprehensive Guide to SQL Server Stored Procedures
What Are Database Stored Procedures? A stored procedure is a set of SQL statements that are written once and then executed whenever...
mike92980
- Jan 13
- 10 min
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft.
mike92980
- Jan 13
- 4 min
What Is SQL
DifferenceSQL (Structured Query Language) is a programming language that is used to manage and manipulate relational databases. It is...
mike92980
- Nov 7, 2022
- 11 min
The Relational Model And Edgar F. Codd's 12 Rules
Edgar F. Codd fundamentally revolutionized the way data could be represented in 1970 with his relational model for databases, which set down
#6 - Test Environment *
#12 - Delete Command
#13 - Group By - Part 1
#14 - Group By - Part 2
#15 - Looping
#16 - Aliasing In T-SQL
#20 - Stored Procedures
bottom of page