MyDatabase, Sql Server

MyDatabase

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'
IF NOT EXISTS (
    select * from sysobjects where name='URK17BI011-MCT-Ex6' and xtype='U'
) CREATE TABLE URK17BI011_MCT_Ex6 (
    [ID_number] INT,
    [Patient_name] NVARCHAR(9),
    [Sex] NVARCHAR(1),
    [Date_of_birth] DATETIME,
    [Age] INT,
    [Total_cholesterol] NVARCHAR(8),
    [Weight] NVARCHAR(6),
    [Height] NVARCHAR(5),
    [body_temperature] NVARCHAR(6),
    [Provider] NVARCHAR(8),
    [A1c] NUMERIC(2, 1),
    [Date_of_last_A1c] DATETIME,
    [Systolic_BP] INT,
    [Diastolic_BP] INT
);
INSERT INTO URK17BI011_MCT_Ex6 VALUES
    (10,N'Irfan',N'M','1999-12-01 00:00:00',21,N'190mg/dl',N'60kg',N'151cm',N'36.5°C',N'alMashfa',6.5,'2006-03-01 00:00:00',140,90),
    (11,N'Ray',N'M','1998-07-04 00:00:00',22,N'185mg/dl',N'50 kg ',N'152cm',N'36.6°C',N'alMashfa',5.7,'2006-02-24 00:00:00',110,75),
    (12,N'Royi',N'F','1998-02-12 00:00:00',22,N'200mg/dl',N'55 kg',N'140cm',N'36.7°C',N'alMashfa',6.3,'2006-01-23 00:00:00',105,85),
    (13,N'Helios',N'F','1999-05-13 00:00:00',21,N'189mg/dl',N'48kg',N'144cm',N'36.6°C',N'alMashfa',7.8,'2006-02-16 00:00:00',131,75),
    (14,N'James',N'M','1996-01-02 00:00:00',24,N'184mg/dl',N'48kg',N'150cm',N'37.2°C',N'alMashfa',6.8,'2005-10-24 00:00:00',120,80),
    (15,N'Tom',N'M','1999-05-05 00:00:00',21,N'170mg/dl',N'58kg',N'153cm',N'37.1°C',N'alMashfa',7.5,'2005-08-06 00:00:00',130,80),
    (16,N'Jerry',N'F','2000-04-04 00:00:00',20,N'201mg/dl',N'49kg',N'148cm',N'37.51C',N'alMashfa',6.2,'2005-12-19 00:00:00',128,77),
    (17,N'Morleyene',N'F','2001-09-05 00:00:00',19,N'205mg/dl',N'59kg',N'198cm',N'38.50C',N'alMashfa',6.4,'2006-01-31 00:00:00',115,80),
    (18,N'Nvidia',N'M','2000-09-06 00:00:00',20,N'150mg/dl',N'69kg',N'168cm',N'36.99C',N'alMashfa',6,'2005-12-17 00:00:00',130,80);


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development