In today’s article, we will learn how to call store procedure and user-defined function ( UDF in Database) from store procedure.

This article lists some important SQL Best Practices with examples.

In this article I provide a quick overview of how to use Filter Setting in SQL Server.

In this article, I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement

In this article, we will discuss how to get the port no of our own SQL Server instance and how to use that port in the SQL Server setting, and at the end how to use that port in your C Sharp applic...

This article discusses how to create databases and tables in MySQL. More emphasis is placed on how to get the details of the latest inserted ID and also the usage of appropriate functions in the ca...

This article explains Inversion of Control and Dependency Injection. Inversion of control is a principle and dependency injection is a way of implementing inversion of control.

In this article, you will learn how to use Index Table variables in SQL Server.

This article shows how to create a subquery to a select statement in SQL Server.

In this article we will learn how to use traditional C# class within SQL-CLR Application.

In this article we will see how to create a simple function in a SQL-CLR Project.

How to use Cursor and XML together in SQL Stored Procedures.

In this article, we create a database in SQL Server and install ASP.NET membership services then install an ASP.NET Memberships Services Database.

How to Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase.

In this article I will demonstrate Binary_Checksum, the Alternate of NewID() to fetch random records in an SQL Server.

In this article, you will learn about Complex SQL queries with the split() function in SQL.

SQL triggers are database objects, a particular kind of stored procedure, which “reacts” to certain actions we make in the database. Learn what is a trigger in SQL Server and how to create triggers...

This article discusses how to create and manage triggers in a database using SQL.

In this article, you will learn how to add primary key in an existing table.

Computed columns are derived columns based on the other existing columns. Computed columns are data types can create based on the situation.