Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Fff
declare @nome varchar(80), @vlr_salario_fixo float, @vlr_comissao float; declare @vlr_total_vendas float, @vlr_salario_total float; set @nome = 'Cesar'; set @vlr_salario_fixo = 1500; set @vlr_total_vendas = 5000; set @vlr_comissao = @vlr_total_vendas * 15 / 100; set @vlr_salario_total = @vlr_salario_fixo + @vlr_comissao; print 'Nome do Vendedor ' + @nome; print 'Salario Fixo ' + cast(@vlr_salario_fixo as varchar); print 'Total Vendas ' + cast(@vlr_total_vendas as varchar); print 'Salario Total ' + cast(@vlr_salario_total as varchar);
run
|
edit
|
history
|
help
0
sql
View jobs
Find gaps in timesheet data between certain hours
exercise
FIGURA5.2
Combined Where and having
Cine latino
TEST 1
split a string into pairs of words
Empleados