Stored Procedure

sp_helpconstraint Stored Procedure in SQL Server

Hi friends, today in SQL Server system stored procedure you will learn how to get information about constraints defined on a table using stored procedure sp_helpconstraint. Sp_helpconstraint stored procedure lists all constraints defined on a table along with their user_defined or system-supplied name. It also lists all columns on which constraints are defined and expressions… Continue reading sp_helpconstraint Stored Procedure in SQL Server

Stored Procedure

Drop extended property using sp_dropextendedproperty in SQL Server

Hi friends today we will continue with other extended properties related stored procedure sp_dropextendedproperty. Sp_dropextendedproperty is used to drop an existing extended property. Syntax of sp_dropextendedproperty is as follows: sp_dropextendedproperty [ @name = ] { ‘property_name’ } [ , [ @level0type = ] { ‘level0_object_type’ } , [ @level0name = ] { ‘level0_object_name’ } [… Continue reading Drop extended property using sp_dropextendedproperty in SQL Server

Stored Procedure

How to Update extended property using sp_updateextendedproperty in SQL Server

Hi friends, today in this blog we will discuss how to updated the extended property. Sp_updateextendedproperty stored procedure is used to update the value of existing extended property. Syntax of sp_updateextendedproperty is as follows: sp_updateextendedproperty [ @name = ]{ ‘property_name’ } [ , [ @value = ]{ ‘value’ } [, [ @level0type = ]{ ‘level0_object_type’… Continue reading How to Update extended property using sp_updateextendedproperty in SQL Server

Stored Procedure

How to add extended property using Sp_addextendedproperty Stored Procedure in SQL Server

Hi friends, in this blog you will learn about sp_addextendedproperty in sql server. Sp_addextendedproperty stored procedure is used to create metadata about our database objects. Using this stored procedure we can put information about Sql server objects like name of developer who created the object, to track the version of objects inside database. Extended properties… Continue reading How to add extended property using Sp_addextendedproperty Stored Procedure in SQL Server

Stored Procedure

Find blocking using sp_who in SQL Server

Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also, we will learn about sp_who stored procedure. Sp_who stored procedure returns information about current SQL server processes, users and sessions. There is another stored procedure sp_who2 which is undocumented stored procedure. Sp_who2provides more comprehensive information… Continue reading Find blocking using sp_who in SQL Server

Uncategorized

How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server

Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating index in Sql Server. What this function does is when it set to ON it will result in NULL values when any value using + operator is NULL, while when CONCAT_NULL_YIELDS_NULL set to OFF it… Continue reading How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server