Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
Demo
QLDT_TUAN 7
/Users/svetlanakanevskaa/Downloads/ACDB.sql
Delete double entries from a table without primary key
Employee Department Interview Questions
Test if a string can be made with substrings!
employees
Task_6_Final
Rename column name using 'sp_rename' command
BC160401693