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
db
bc160402152
20181CSE0068
Pro 2
ms sql - update/insert - date concatenation
IOU
service_delivery_task
delete all data from given scheme tables
reee
Window Functions - ROW_NUMBER()