create table ALPHABET
(
id int IDENTITY(1,1),
Characters NCHAR(1) PRIMARY KEY )
DECLARE @asciiCode INT= 65 WHILE @asciiCode <= 90 BEGIN
INSERT ALPHABET ( Characters ) SELECT CHAR(@asciiCode)
SELECT @asciiCode = @asciiCode + 1
END
USE [master]
GO
/****** Object: Table [dbo].[order_point] Script Date: 04/02/2018 18:35:33 ******/
CREATE TABLE [dbo].[order_point](
[order1] [varchar](50) NULL,
[point] [int] NULL,
[numero2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order1', 1)
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order2', 1)
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order3', 3)
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order4', 6)
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order5', 8)
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order6', 10)
INSERT [dbo].[order_point] ([order1], [point]) VALUES (N'Order7', 10)
update C
set C.numero2=A.Characters
from ALPHABET A
INNER JOIN order_point C
ON C.point=A.id
select * from ALPHABET
select * from order_point