Let's assume you want to loop through a table variable having a structure like below. DECLARE @tempCategories TABLE ( Id INT, CategoryName NVARCHAR(500),)Now, to iterate through this table, just add…

In this blog, I am sharing the key points which I noted while learning the basics & getting started points for writing the database unit test case for SQL Server.Installation: ○ tSQLt must be…

To check bytes used by a variable in SQL Server, you can use DATALENGTH function.DECLARE @temp NVARCHAR(MAX)SET @temp = N'化字'SELECT DATALENGTH(@temp)This will display the number of bytes used @temp…

To determine the code-point value of a Unicode character in SQL Server, you can use UNICODE function which is provided by default in SQL Server.For example, if you want to determine what is the…

Below small query will list all the procedures that contains specific text.SELECT OBJECT_NAME(object_id), definitionFROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1AND…

You can follow below steps to deploy a database to SQL Server from the .dacpac file. To deploy the database from dacpac, we will be using SQLPackage.exe. SQLPackage.exe is a command line utility that…

Use below script to update schema of a table in SQL Server. ALTER SCHEMA NewSchema TRANSFER CurrentSchema.TableName; i.e. Suppose you want to change your dbo.Customers table to Config.customers, then…

Yesterday, when I was trying to delete my database from the web panel of GoDaddy hosting. I got this issue. I was not able to delete my database and I was being shown this message.I just googled it…