Shulou(Shulou.com)05/31 Report--

This article mainly introduces mssql how to copy ID, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

USE [master]

GO

/ * Object: StoredProcedure [dbo]. [sp_hexadecimal] Script Date: 17:35:36 on 2017-8-16 * /

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo]. [sp_hexadecimal]

@ binvalue varbinary (256)

Hexvalue varchar (514) OUTPUT

AS

DECLARE @ charvalue varchar

DECLARE @ I int

DECLARE @ length int

DECLARE @ hexstring char (16)

SELECT @ charvalue = '0x'

SELECT @ I = 1

SELECT @ length = DATALENGTH (@ binvalue)

SELECT @ hexstring = '0123456789ABCDEF'

WHILE (@ I)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.