I have a table that has a unique identifier of "name" and two fields that are both Boolean statements. The two fields are titled "sentbirth" and "senthire".
What I am trying to do is to see if the value is already true for senthire or sentbirth. If so I want to leave it as true. But if it is false then I want it to update with the @SentBirth or @SentHire value that is being produced from my web application.
What I have so far is:
SELECT [name],[sentbirth],[senthire]
FROM [table]
WHERE name = @Name
IF [sentbirth] = '1'
BEGIN
UPDATE [CCRAuction].[dbo].[cardsUser]
SET [sentbirth] = '1'
END
ELSE
BEGIN
UPDATE [CCRAuction].[dbo].[cardsUser]
SET [sentbirth] = @SentBirth
END
IF [senthire] = '1'
BEGIN
UPDATE [CCRAuction].[dbo].[cardsUser]
SET [senthire] = '1'
END
ELSE
BEGIN
UPDATE [CCRAuction].[dbo].[cardsUser]
SET [senthire] = @SentHire
END
With this code as is I am receiving the error message that 'sentbirth' and 'senthire' are invalid column names.
How do I write this code properly in Microsoft SQL Server Management Studio?
Aucun commentaire:
Enregistrer un commentaire