SQL Server Education (by the geeks, for the geeks)
Hi friends, today we will continue with other extended properties related stored procedure which is sp_updateextendedproperty. Sp_updateextendedproperty stored procedure is used to update the value of existing extended property. Syntax of …
sp_updateextendedproperty – Day 3 – SQL Server System Stored Procedure Read MoreHi friends, today in SQL server system stored procedure series we will look into stored procedure sp_addextendedproperty. Sp_addextendedproperty stored procedure is used to create metadata about our database objects. Using this …
sp_addextendedproperty – Day 2 – SQL Server System Stored Procedure Read MoreHi Folks, I am starting a new series system stored procedures in SQL Server. In this series you will learn about many useful stored procedures which we use in our day-to-day …
sp_who – Day 1 – SQL Server System Stored Procedure Read MoreHi friends, while working a scenario I found some interesting fact about @@TRANCOUNT when we used IMPLICIT transaction & BEGIN TRANSACTION in Sql Server. I will create some scenarios and we …
IMPLICIT transaction & BEGIN TRANSACTION in Sql Server Read MoreHi all, today I was working on a script in which I have to extract data from a table which is not present in another table. I know that it can …
LEFT JOIN vs EXCEPT in Sql Server Read MoreHello Geeks, Thank you for being part of the SQLServerGeeks SQL Server Day on 17th Jan, 2015. It is a wonderful feeling to come back with three events in three cities. …
Buckle up for Feb 14 – Spread love for SQL Server Read MoreHi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns in Sql Server. What this function does is when it set to ON …
Effect Of CONCAT_NULL_YIELDS_NULL For Computed Columns In Sql Server Read MoreThis blog is intended to be a guideline for installing SQL Server in Windows Server environments. This came about as I am heavily involved with virtualizing SQL Server in different Windows environments. …
SQL Server in Windows Server Environment Read MoreHi friends, In this blog I will discuss about Synonyms in SQL Server. Synonyms are the database object which is used to provide an alternative name to other database objects. We …
Synonyms in SQL Server Read MoreHi Friends, This is my first blog for SqlServerGeeks. In this blog I am going to tell about drop index on View in Sql Server. Views are virtual tables in which …
Drop Index on View in SQL Server Read More