CoderJony

SQL Server

How to check code point value of a Unicode character in SQL Server?

How to check code point value of a Unicode character in SQL Server?

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.

Read More By Ankush Jain
How to find Stored Procedures containing specific text in SQL Server?

How to find Stored Procedures containing specific text in SQL Server?

Below small query will list all the procedures that contains specific text.

Read More By Ankush Jain
How to deploy dacpac using SQLPackage.exe

How to deploy dacpac using SQLPackage.exe

To deploy the database from dacpac, we will be using SQLPackage.exe.

Read More By Ankush Jain
How to change schema name of a table in SQL Server?

How to change schema name of a table in SQL Server?

Use below script to change schema name of a table in SQL Server.

Read More By Ankush Jain
SQL Server Error- Unable to delete the database user as the user is already logged in currently.

SQL Server Error- Unable to delete the database user as the user is already logged in currently.

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.

Read More By Ankush Jain