text: --Simple logical test
  If 'Yes'='Yes'
  Print 'True'
  
  --Change code based on a condition
  UPDATE SalesLT.Product
  SET DiscontinuedDate=getdate()
  WHERE ProductID=1;
  
  IF @@ROWCOUNT<1
  BEGIN
  	PRINT 'Product was not found'
  END
  ELSE
  BEGIN
  	PRINT 'Product Updated'
  END
  