libxkbcommon-x11-0
01:00.0 3D controller: NVIDIA Corporation GK106M [GeForce GTX 765M] (rev a1)
tab
/*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;*/
ref: Here
/*
CREATE TABLE nNkgName (
PK_nkgID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Names varchar(16),
);
*/
/*
CREATE TABLE nDevice (
PK_deviceID int NOT NULL PRIMARY KEY IDENTITY(1,1),
SN varchar(32) NOT NULL,
FK_nkgID int,
CONSTRAINT FK_nkgID FOREIGN KEY (FK_nkgID) REFERENCES nNkgName (PK_nkgID) ON DELETE CASCADE ON UPDATE CASCADE,
);
*/
/*
CREATE TABLE nClient (
PK_clientID int NOT NULL PRIMARY KEY IDENTITY(1,1),
MobileName nvarchar(64),
MobileAppName nvarchar(32),
);
*/
/*
CREATE TABLE nLevel (
PK_levelID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Title nvarchar(64),
);*/
/*
CREATE TABLE nManagerInfo (
PK_managerID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Email varchar(256) NOT NULL,
Names nvarchar(128),
FK_levelID int,
CONSTRAINT FK_levelID FOREIGN KEY (FK_levelID) REFERENCES nLevel (PK_levelID) ON DELETE CASCADE ON UPDATE CASCADE,
FK_clientID int,
CONSTRAINT FK_clientID FOREIGN KEY (FK_clientID) REFERENCES nClient (PK_clientID) ON DELETE CASCADE ON UPDATE CASCADE,
FK_deviceID int,
CONSTRAINT FK_deviceID FOREIGN KEY (FK_deviceID) REFERENCES nDevice (PK_deviceID) ON DELETE CASCADE ON UPDATE CASCADE
);
*/
/*
CREATE TABLE nSampleName (
PK_sampleID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Names varchar(128),
);
*/
/*
CREATE TABLE nSampleType (
PK_stypeID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Types varchar(32),
);
*/
/*
create table nDataPackage
(
PK_datapackageID int NOT NULL PRIMARY KEY IDENTITY(1,1),
DataPackage nvarchar(max) CHECK (ISJSON(DataPackage)=1),
StartTime DateTime default SYSDATETIMEOFFSET(),
EndTime DateTime default SYSDATETIMEOFFSET(),
FK_managerID int,
CONSTRAINT FK_managerID FOREIGN KEY (FK_managerID) REFERENCES nManagerInfo (PK_managerID) ON DELETE CASCADE ON UPDATE CASCADE,
FK_sampleID int,
CONSTRAINT FK_sampleID FOREIGN KEY (FK_sampleID) REFERENCES nSampleName (PK_sampleID) ON DELETE CASCADE ON UPDATE CASCADE,
FK_stypeID int,
CONSTRAINT FK_stypeID FOREIGN KEY (FK_stypeID) REFERENCES nSampleType (PK_stypeID) ON DELETE CASCADE ON UPDATE CASCADE
);
*/
CREATE TABLE nDashBoard (
PK_dashboardID int NOT NULL PRIMARY KEY IDENTITY(1,1),
Content nvarchar(2000) CHECK (ISJSON(Content)=1),
UploadTime DateTime default SYSDATETIMEOFFSET(),
SignalQuality int,
FK_mgrID int,
CONSTRAINT FK_mgrID FOREIGN KEY (FK_mgrID) REFERENCES nManagerInfo (PK_managerID) ON DELETE CASCADE ON UPDATE CASCADE
);
沒有留言:
張貼留言