In this article, you will learn about how to create a stored procedure in SQL Server using SSMS.

In this article, we will see how to call a function from a stored procedure in SQL Server.

SQL Server Management Studio (SSMS). This article explains how to download and install SQL Server Management Studio 2017.

This article describes the differences between a stored procedures and a function in SQL Server.

In this post, learn how to add a Primary Key, Unique Keys, or a Foreign Keys to an existing table using a SQL query.

In this article, you will see how to use a Static Cursor in SQL Server.

Today, we will learn how to find a Primary Key, Unique Key, or a Foreign Keys in a table using SQL and how to delete a primary key, unique key, or a foreign key from a table using SQL.

In this article, you will learn how to prevent SQL Injection.

In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply funct...

In this article we are going to see what Data Flow Transformations in SSIS are and the list of controls that are provided in the data flow transformations followed by a series about each control in...

In this article, we’ll learn to give READ and WRITE permission to user after creating their login in SQL Server.

Grant SQL statement grants permissions on an object to a user. Revoke removes permissions on an object. In this article, learn about Grant and Revoke in SQL Server.

In this article we will learn about SELECT statements in SQL Server.

How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.

Simplify complex joins and subqueries using SQL Server Common Table Expressions or CTEs. It also provides a way to query hierarchical data. This article provides a complete overview of CTEs, types ...

Do you wonder the difference between nvarchar vs varchar? This article discusses the differences between CHAR, VARCHAR, NCHAR and NVARCHAR data types. CHAR vs VARCHAR, NCHAR vs NVARCHAR, difference...

In this article, you will learn about 50 Important Queries in SQL Server. EXEC sp_helpdb, exec sp_helptext, EXEC sp_updatestats, EXEC sp_MSforeachtable, SQL query for version name of SQL Server, En...

This article helps you to create a stored procedure in SQL Server and learn how to use a stored procedure in an ASP.NET application.

Know the SQL server maintenance plan best practices with scripts & without scripts. This guide has the best SQL server maintenance solution in simple tasks for users.

We will learn how to Format Date and Time in SQL Server Using FORMAT Function.