27 lines
970 B
Transact-SQL
27 lines
970 B
Transact-SQL
DECLARE @UserId INT
|
|
DECLARE @PropertyId INT
|
|
DECLARE @PropertyValue [NVARCHAR] (MAX)
|
|
|
|
SELECT @UserId = ID FROM Users WHERE UserName = 'TSRAIRUser'
|
|
IF (@UserId IS NOT NULL)
|
|
BEGIN
|
|
SELECT @PropertyId = PropertyId FROM [dbo].[DefaultProperties] WHERE PropertyName = 'DefaultViewAll'
|
|
IF (@PropertyId IS NULL)
|
|
BEGIN
|
|
INSERT INTO [dbo].[DefaultProperties] (PropertyName, DefaultValue) VALUES ('DefaultViewAll', 'False')
|
|
SELECT @PropertyId = PropertyId FROM [dbo].[DefaultProperties] WHERE PropertyName = 'DefaultViewAll'
|
|
END
|
|
IF (@PropertyId IS NOT NULL)
|
|
BEGIN
|
|
SELECT @PropertyValue = PropertyValue FROM [dbo].[UserProperties] WHERE UserId = @UserId AND PropertyId = @PropertyId
|
|
IF (@PropertyValue IS NULL)
|
|
BEGIN
|
|
INSERT INTO [dbo].[UserProperties] VALUES (@UserId, @PropertyId, 'True')
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
UPDATE [dbo].[UserProperties] SET PropertyValue = 'True' WHERE UserId = @UserId AND PropertyId = @PropertyId;
|
|
END
|
|
END
|
|
END
|