SQL中小技巧代码

1.对于多个传入字段，同时只允许一个有值，返回非空字段的编号

declare
  @vc_holder_name     varchar(255),
  @vc_officer_name    varchar(255),
  @vc_enterprise_name varchar(255),
  @vc_family_name     varchar(255),
  @vc_temp            varchar(255)

select
  @vc_holder_name    ='xx',    
  @vc_officer_name   ='',
  @vc_enterprise_name='',
  @vc_family_name    ='',
  @vc_temp           =''
  
if (len(left(@vc_holder_name,1))%2+len(left(@vc_officer_name,1))%2+len(left(@vc_enterprise_name,1))%2+len(left(@vc_family_name,1))%2)<>1
print '不能同时有值,也不能同时为空!'
else
begin
  select @vc_temp=convert(varchar,len(left(@vc_holder_name,1))%2)
    +convert(varchar,len(left(@vc_officer_name,1))%2)
    +convert(varchar,len(left(@vc_enterprise_name,1))%2)
    +convert(varchar,len(left(@vc_family_name,1))%2)
  print '非空字段序号:'+convert(varchar,charindex('1',@vc_temp))
end