Tutorials
Courses

SQL Server

161+ posts

How to Declare a Variable in SQL Server?

Last Updated: 23 August 2024

In SQL Server, variables play a critical role in the dynamic execution of SQL scripts and procedures. Variables allow you to store and manipulate data temporarily within t...read more

Picked

SQL Server

Databases

SQL Server Replication

Last Updated: 28 August 2024

SQL Server Replication is a robust feature used to distribute and synchronize data across multiple databases, ensuring consistency and data integrity. By leveraging the "P...read more

SQL Server

Databases

SQL Server - FILESTREAM

Last Updated: 28 August 2024

Managing unstructured data such as images, documents, and videos has traditionally been a challenge in relational databases. SQL Server addressed these challenges with the...read more

DBMS

SQL Server

Databases

INNER JOIN ON vs WHERE clause in SQL Server

Last Updated: 10 September 2024

In SQL Server, joining tables and filtering data are essential for retrieving meaningful information. The INNER JOIN operation is used to combine rows from multiple tables...read more

Picked

SQL Server

Databases

Can a Foreign Key be NUll in SQL Server?

Last Updated: 26 September 2024

In SQL Server, foreign keys are essential to maintaining relationships between tables and enforcing referential integrity. A foreign key is a column (or set of columns) in...read more

Picked

SQL Server

Databases

Rename column SQL Server 2008

Last Updated: 10 September 2024

Renaming a column in a database is a common task that often arises when users want to change the database schema. In SQL Server 2008, renaming columns can be done efficien...read more

Picked

SQL Server

Databases

How to Convert DateTime to VarChar in SQL Server

Last Updated: 26 September 2024

In SQL Server, date and time values are often stored in theDATETIMEorDATEdata types. However, there are situations where we may want to convert these values into a differe...read more

Picked

SQL Server

Databases

When Should We Use CROSS APPLY Over INNER JOIN?

Last Updated: 20 September 2024

In SQL Server, both INNER JOIN and CROSS APPLY are used to combine data from multiple tables, but they serve different purposes and have distinct use cases. INNER JOIN is ...read more

Picked

SQL Server

Databases

How to Delete using INNER JOIN with SQL Server?

Last Updated: 24 September 2024

In SQL Server, we can useINNER JOINwithin aDELETEstatement to remove data from one table based on matching records in another table. This method is useful when we need to ...read more

Picked

SQL Server

Databases

Count(*) vs Count(1) in SQL Server

Last Updated: 27 September 2024

In SQL Server, theCOUNT()function is used to return the number of rows in a query result. There are different ways to use theCOUNT()function such asCOUNT(*)andCOUNT(1). A...read more

Picked

SQL Server

Databases

How to Update Table Rows in SQL Server using Subquery ?

Last Updated: 11 October 2024

Updating table rows in SQL Server using a subquery is a common operation that allows us to modify records based on values derived from another table or query. In this arti...read more

Picked

SQL Server

Databases

Find the Length of a Series Using Window Functions in SQL Server

Last Updated: 11 October 2024

Window functionsin SQL Server are a powerful tool for performing calculations across a series of rows related to the current row. Unlike aggregate functions, which combin...read more

Picked

SQL Server

Databases

How to Index Foreign Key Columns in SQL Server

Last Updated: 01 October 2024

Indexing foreign key columns in SQL Server is a vital optimization strategy for enhancing query performance, particularly when dealing with JOIN operations between related...read more

Picked

SQL Server

Databases

SQL Server - Database Objects

Last Updated: 08 October 2024

In SQL Server,database objectsare essential components that allow to store and manage data effectively. These objects can range from tables and views to stored procedures ...read more

Picked

SQL Server

Databases

How to Display the Database Name in the Result of a Query?

Last Updated: 02 January 2025

When working with multiple databases in SQL Server by identifying the source of data in query results is crucial. This is especially important for auditing, reporting, and...read more

Picked

SQL Server

Databases

1 2 3 4

...