/*INSERT INTO nNKGName([Names]) values ('BCX');*/
/*DELETE FROM nDevice WHERE PK_deviceID >= 0;
DBCC CHECKIDENT (nDevice, RESEED, 0);*/
/*insert into dbo.nNkgName (Names) values('BCX');*/
/*insert into dbo.nNkgName (Names) values('321') select scope_identity();*/
/*insert into nDevice ([SN], [FK_nkgID]) values ('sn2234', (select PK_nkgID from nNKGName where PK_nkgID = '1'));*/
/*insert into nDevice (SN, FK_nkgID) values ('kk1234', 3);*/
/*insert into nClient (MobileName, MobileAppName) values ('samsung note 9', 'bcx');*/
/*insert into nLevel (title) values ('coach');*/
/*insert into nManagerInfo (Email, Names, FK_levelID, FK_clientID, FK_deviceID) values ('nice123@gmail.com', 'nice', 1, 1, 3);*/
/*SELECT nDevice.PK_deviceID, nDevice.SN, nNKGName.Names FROM nDevice INNER JOIN nNkgName ON nDevice.FK_nkgID=nNkgName.PK_nkgID;*/
/*select PK_nkgID,Names from nNKGName where nNKGName.Names='BCX';*/
/*UPDATE nDevice SET nDevice.SN='sn2222', nDevice.FK_nkgID='5' where nDevice.PK_deviceID=2;*/
/*UPDATE nDevice SET nDevice.SN='sn2222', nDevice.FK_nkgID=(select PK_nkgID from nNKGName where PK_nkgID = 3) where nDevice.PK_deviceID=2;*/
/*UPDATE nDevice SET nDevice.SN='sn2222', nDevice.FK_nkgID=(SELECT nNkgName.PK_nkgID FROM nNkgName WHERE nNkgName.Names='666') where nDevice.PK_deviceID=2;*/
/*delete from nDevice where nDevice.SN='aa1234';*/
/*SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'nManagerInfo';*/
/*UPDATE nManagerInfo SET nManagerInfo.Names='bob4', nManagerInfo.FK_levelID=1,nManagerInfo.FK_clientID=1, nManagerInfo.FK_deviceID=6 where nManagerInfo.Email='bob3@gmail.com';*/
/*DELETE from nManagerInfo WHERE nManagerInfo.Email='bob2@gmail.com'*/
/*DBCC CHECKIDENT ('nDataPackage',RESEED,1)*/
/*insert into nDataPackage (DataPackage, StartTime, EndTime, FK_managerID, FK_sampleID, FK_stypeID) values ('{"HR":60, "RRI":1.7}', '20201108 07:00', '20201108 08:00', 12, 1, 2);*/
/*truncate table nDataPackage;*/
/*insert into nDashBoard (Content, FK_mgrID, UploadTime, SignalQuality) values ('{"HR":67, "RRI":1.7}', 11, '20201108 07:00', 1);*/
/*UPDATE nDashBoard SET nDashBoard.Content='{"HR":61, "RRI":1.7}', nDashBoard.UploadTime='2020-10-11 07:00:00.0', nDashBoard.SignalQuality=0 where nDashBoard.FK_mgrID=11;*/
SELECT * FROM nSampleType;
/*SELECT top 1 nNkgName.PK_nkgID FROM nNkgName WHERE nNkgName.Names='BCX';*/
/*SELECT * FROM nManagerInfo;*/
/*SELECT * FROM nDataPackage;*/
/*SELECT * FROM nManagerInfo;
SELECT * FROM nLevel;
SELECT * FROM nClient;
SELECT * FROM nDevice;*/
/*-----------multi condition--------------*/
/*WITH
query1 AS
(
SELECT
ROW_NUMBER() OVER(ORDER BY Id ASC) AS kkk,*
FROM BxpxxwManagerInfo
WHERE Email LIKE '%york%'
)
SELECT * FROM query1 where kkk > 1 and kkk < 3;*/