Instantly share code, notes, and snippets.

Embed
What would you like to do?
use AdventureWorks2012
go
declare @vars int;
declare @vars2 int;
select @vars = count(*) from sales.SalesOrderHeader
select @vars2 = count(*) from sales.SalesOrderDetail
IF @vars > 3000 and @vars2 = @vars
begin
print 'wah cukup banyak yang aneh'
end
else if @vars > 3000 and @vars2 <> @vars
begin
print 'wah cukup banyak'
end
else
begin
print 'sedikit banget'
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment