Declare @MakeFlag bit
select @MakeFlag=MakeFlag from Production.Product
Where Name ='Chaining Bolts'
If @MakeFlag=1
Print 'The Stock is available'
else
Print 'The stock is not available'
select @MakeFlag=MakeFlag from Production.Product
Where Name ='Chaining Bolts'
If @MakeFlag=1
Print 'The Stock is available'
else
Print 'The stock is not available'
No comments:
Post a Comment