SQL Server is a relational database management system (RDBMS) developed by Microsoft.
In this blog, we are listing the different types of SQL Server Languages termed as commands or statements. These statements or commands are categorized as per their functionality. SQL Server Languages or Commands There are mainly four types of language statements or commands in SQL Server – DML, DDL, DCL, and TCL. Let’s find out […]
SQL Server Languages – DML, DDL, DCL & TCL Read More »
Varchar and Varchar(max) data types are very important in SQL Server. In this post, we will discuss the differences between varchar and varchar(max) in SQL Server. The main purpose of this post is to make it clear what to use and when with respect to the varchar and varchar(max) data type in SQL Server. Introduction
Practical 5 Varchar and Varchar(max) Differences in SQL Server, 4th one is the best Read More »
How to Exclude Saturday and Sunday Using SQL Query? 🤔 While working with one of the applications, I came across a requirement to get records from the SQL Server database by excluding the weekend’s data. Introduction I was wondering at first but then divided the problem and worked on it part by part to get
Brilliant Ways to Exclude Saturday and Sunday using SQL Query Read More »
In this post, we will be listing the top 11 SQL Server keyboard shortcuts you must know. Before that let’s have a bit of information about SQL Server. SQL Server is a relational database management system (RDBMS) developed by Microsoft. Introduction As a Database Server, it is a software product with the primary function of
Popular Top 11 SQL Server Keyboard Shortcuts Read More »
Temporary tables and Table variables, both have their own pros and cons. So it’s the developer who needs to decide which one to use and when according to the use cases and requirements. In this post, we will learn the differences between Temporary Tables And Table Variables In SQL Server. Temporary tables and Table variables
Temporary Tables and Table Variables in SQL Server Easy Explaination Read More »