Tolerant/convert_guid_to_hex_string.sql

Created May 3, 2018 11:17

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Tolerant/1f63f3b6c11ae4e2aad5de15d4625d81.js"></script>
Save Tolerant/1f63f3b6c11ae4e2aad5de15d4625d81 to your computer and use it in GitHub Desktop.

Download ZIP

Convert 1с guid to HEX string

Raw

convert_guid_to_hex_string.sql

	SELECT TOP 10
	CONVERT(UNIQUEIDENTIFIER, CONVERT(BINARY(16), Fld)) AS guid
	FROM [DATABASE]..[Info]
	ORDER BY _Period DESC;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment