sql - Selecting Columns Based on Case or If Statements -

sql - Selecting Columns Based on Case or If Statements -

i wan't display columns based on conditions/parameters want is

if(@selectflag==true) select name,address,salary,createdby employee else (@updateflag==true) select name,address,salary employee -- in case don't require column "createdby"

how can create query or stored procedure looking @ above circumstances..

thanks & regards..

use single = , 1 instead of true.

if @selectflag = 1 select name, address, salary, createdby employee else if @updateflag = 1 select name, address, salary employee

sql sql-server sql-server-2008 tsql