Tag: T-SQL

SQL Server - Recuperare il Product Key da una installazione esistente
Coding / SQL

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database

- by Ryan - Leave a Comment

If you've stumbled upon this post it most likely means that you need to change the type and/or format of one or more table column of a SQL Server using …

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database Read More
SQL Server - Recuperare il Product Key da una installazione esistente
Coding / SQL / Windows

SQL Server - Reset the numeric counter (seed) of an Identity column How to reset the numeric value of the seed counter of an identity column with SQL Server 2002, 2005, 2008, 2008R2, 2012, 2016, 2017, 2019

- by Ryan - Leave a Comment

If you came across this article, you probably need to reset the numeric value (seed counter) of an identity column used by a table in your SQL Server database. The …

SQL Server - Reset the numeric counter (seed) of an Identity column How to reset the numeric value of the seed counter of an identity column with SQL Server 2002, 2005, 2008, 2008R2, 2012, 2016, 2017, 2019 Read More
SQL Server - Recuperare il Product Key da una installazione esistente
Coding / Servers & Services / SQL / Windows

SQL Server - Call a URL using GET or POST method and fetch Status Code and Response Text How to execute a GET or POST call to an external URL within a Stored Procedure (using HTTP or HTTPS protocol) and retrieve the StatusCode and ResponseText

- by Ryan - 4 Comments.

We already talked about the MSXML2.XMLHTTP and MSXML2.ServerXMLHTTP objects in an older post: these objects provides methods and properties for server-safe HTTP access between different Web servers and can be used to exchange …

SQL Server - Call a URL using GET or POST method and fetch Status Code and Response Text How to execute a GET or POST call to an external URL within a Stored Procedure (using HTTP or HTTPS protocol) and retrieve the StatusCode and ResponseText Read More
SQL - The ntext data type cannot be selected as DISTINCT because it is not comparable - How to Fix
Coding / SQL

SQL - The ntext data type cannot be selected as DISTINCT because it is not comparable - How to Fix How to fix the "The ntext data type cannot be selected as DISTINCT because it is not comparable" error affecting MS SQL Server and other DBMS based on T-SQL

- by Ryan - Leave a Comment

If you've stumbled upon this post you're probably dealing with a SQL / T-SQL query which is either doing: a DISTINCT on a column having ntext data type. a JOIN with multiple …

SQL - The ntext data type cannot be selected as DISTINCT because it is not comparable - How to Fix How to fix the "The ntext data type cannot be selected as DISTINCT because it is not comparable" error affecting MS SQL Server and other DBMS based on T-SQL Read More