Code with confidence
Code with confidence
Sometimes it is required to find out the details like product version, edition and server version of MSSQL server. Below is the query to find out these detail easily. Below is the output of query. I hope you find it…
There are times when we required identity columns values to updated as per the application logic and flow. But how can update the identity column. Let us see below how we can achieve this. We have to use IDENTITY_INSERT which allows explicit…
Some times it is required you to share some database on MSSQL server to users with read-only access. This is very easy and can be setup in 2 minutes only. The concept is very simple you just have to create…
you're currently offline
