Introduction In this post, we will see how to configure the Azure SQL database using vs 2019. This post is a continuation of how to provision a relational database. To read more about how to provision the relational database in the Azure portal, take a look at my post provision and configure relational databases azure […]
Browsing Tag: sql
SQL
How to: Create CLR stored procedure and Work with CLR database object
In this Article, you will learn how to work with CLR database object to create CLR stored procedure using c# with vs 2019. I have covered couple of simple examples in this article. Also, I will walk you through the errors that you might encounter while you follow this article. Also, you will learn how […]
SQL
How to delete all duplicate rows but keeping one in sql
This post is on how to delete all duplicate rows but keeping one in sql. In this post, I will explain how to delete duplicate records from a table in detail with example and proof for the said solution. This is a real time scenario that I have undergone personally in my day today work. […]