PeopleOutfit (id int primary key, boots int, hat int)

UpdateOutfit @id int, @newBoots int = null, @newHat = null

exec UpdateOutfit @id=1, @newBoots=null, @newHat=5

exec UpdateOutfit @id=1, @newHat=5

SELECT
    st.text
FROM
    sys.dm_exec_requests r
CROSS APPLY
    sys.dm_exec_sql_text(sql_handle) AS st
WHERE
    r.session_id = @@SPID