QQ81371336的专栏

转载 实用用的sql语句

1．SQL插入语句得到自动生成的递增ID值<br />insert into Table1(Name,des,num) values ('ltp','thisisbest',10);<br />select @@identity as 'Id'2．实现是1或0想显示为男或女<br />select name,Sex=<br />  case Sex<br />  when '1' then '男'<br />  when '0' then '女'<br />  end<br />from Tablename