Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Train Reservation
Insert index into Temporary Table
UNPIVOT
OFFSET FETCH Clause
self join
Teacher
SQL HW 1 Appline
get first parent with a value
Demo
arithmetic
Please log in to post a comment.