- --- CREATE TEMP TABLE
- CREATE TABLE ##TempIDCHAR
- (
- [ID] INT
- )
-
- --- DECLARE VARIABLE --
- DECLARE @Max AS int
- DECLARE @Value AS int
-
- SET @Max = 255
- SET @Value = 32
-
- --- INSERT VALUE ----
- WHILE @VALUE <= @Max
- BEGIN
- INSERT INTO ##TempIDCHAR
- SELECT @VALUE
-
- SELECT @VALUE = @VALUE + 1
- END
-
- --- LISTING --------
- SELECT
- ID AS VALEURUNICODE,
- CHAR(ID) AS TEXTE
- FROM
- ##TempIDCHAR
-
- --- DELETE TEMP TABLE
- DROP TABLE ##TempIDCHAR
- --- LISTING DES COMPTES
--- CREATE TEMP TABLE
CREATE TABLE ##TempIDCHAR
(
[ID] INT
)
--- DECLARE VARIABLE --
DECLARE @Max AS int
DECLARE @Value AS int
SET @Max = 255
SET @Value = 32
--- INSERT VALUE ----
WHILE @VALUE <= @Max
BEGIN
INSERT INTO ##TempIDCHAR
SELECT @VALUE
SELECT @VALUE = @VALUE + 1
END
--- LISTING --------
SELECT
ID AS VALEURUNICODE,
CHAR(ID) AS TEXTE
FROM
##TempIDCHAR
--- DELETE TEMP TABLE
DROP TABLE ##TempIDCHAR
--- LISTING DES COMPTES