Skip to content

Instantly share code, notes, and snippets.

@radityopw

radityopw/tsql_4.sql

Created March 1, 2016 01:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save radityopw/dedda8ea5ce66bee80a3 to your computer and use it in GitHub Desktop.
Save radityopw/dedda8ea5ce66bee80a3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tsql_4.sql
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