What is SQL Server Database
A SQL Server Database is an organized collection of data and supporting data structure & tools to manage it. The data is stored in a series of tables. A database does not only contain the data but also contains
SQL Server
Reserved Keywords in SQL Server
This Article lists the Reserved Keywords in SQL Server. The identifiers we give to the database objects like column names and table names etc should not use these words. If you want to use them, then you should always use the Delimited format by enclosing them in square brackets [] or double quotation marks (“”)
Regular & Delimited Identifiers in SQL Server
Identifiers are the name we give to the Servers, Databases, and Database objects, such as Tables, Views, Columns, Indexes, Triggers, Procedures, Constraints, and Rules, etc. They must uniquely identify them. We then use the identifier to refer to the server, database, table whenever we want to use them. There are certain rules & restrictions that we must follow when we choose the name for the identifier.
How to download and install SQL Server 2019
In this how-to guide, we learn how to download and install SQL Server 2019 step by step. We will download the SQL Server developer edition / SQL Server Express edition and show you how to install it. The guide uses the Windows 10 OS. But you can install it in other editions of windows. The list of Supported OS, Hardware and software requirements are listed below
Cross Join by Example in SQL Server
Cross join joins each row of one table with each row of another table. The result of the cross join is a Cartesian product (also called the cross product) of the two.