sql

Sql code posted by sqler
created at 28 Jan 07:57, updated at 05 Mar 18:49

Edit | Back
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
SELECT * FROM [mgaeh_LIBERO ITS].[dbo].[ProfileKeyValue]

INSERT INTO ProfileKeyValue (ProfileId, ProfileSectionId, ProfileKeyId, Value) 
(SELECT Id, (SELECT Id FROM ProfileSection WHERE Name = 'ChipConfig'), (SELECT Id FROM ProfileKey WHERE Name = 'TiLimHNB'), 0 from Profile)

INSERT INTO ProfileKeyValue (ProfileId, ProfileSectionId, ProfileKeyId, Value) 
(SELECT Id, (SELECT Id FROM ProfileSection WHERE Name = 'ChipConfig'), (SELECT Id FROM ProfileKey WHERE Name = 'TiLimLNB'), 0 from Profile)




(SELECT Id, 99, 99, 'huch' from Profile)


(SELECT Id, (SELECT Id FROM ProfileSection WHERE Name = 'ChipConfig'), (SELECT Id FROM ProfileKey WHERE Name = 'TiLimHNB'), 0 from Profile)



SELECT Id, Name FROM ProfileKey WHERE Name like 'TiLimHNB'

delete from ProfileKeyValue where Value = 'huch'

INSERT into ProfileKey (Id, Name) VALUES (59, 'TiLimHNB')
INSERT into ProfileKey (Id, Name) VALUES (60, 'TiLimLNB')

SELECT *  FROM ProfileKey

INSERT ProfileSectionKeyProperties([ProfileSectionId],[ProfileKeyId],[Changeable],[ExcludeHash]) SELECT (SELECT [Id] FROM ProfileSection WHERE [Name] = 'ChipConfig'), (SELECT [Id] FROM ProfileKey WHERE [Name] = 'TiLimHNB'),1,0
INSERT ProfileSectionKeyProperties([ProfileSectionId],[ProfileKeyId],[Changeable],[ExcludeHash]) SELECT (SELECT [Id] FROM ProfileSection WHERE [Name] = 'ChipConfig'), (SELECT [Id] FROM ProfileKey WHERE [Name] = 'TiLimLNB'),1,0
1.39 KB in 7 ms with coderay