Set A Variable In A Stored Procedure From A Select Statement

DECLARE @Value

INSERT @Value = (SELECT SomeColumn1 FROM SomeTable WHERE SomeColumn2 = @SomeParameter)

Advertisements