Sqlserver随记汇总
1.SqlServer查询表结构:
sp_help 表名
2.细节注意,最后的end需要加上,完整语法:case .. when .. then .. else .. end
where orderType = case @orderType when -1 then orderType else @orderType end
3.两种连接字符串方式:
<connectionStrings> //Sqlserver身份验证 <add name="DbConnect" connectionString="server=.\SqlExpress;database=GradeManage;uid=sa;pwd=sa" providerName="System.Data.SqlClient"/> //Windows身份验证 <add name="DbConnect" connectionString="server=.\SqlExpress;database=GradeManage;Trusted_Connection=SSPI;" providerName="System.Data.SqlClient"/> </connectionStrings>
4.Sql想表中插入时间字段:
insert into tbgameappconfig (gameid, appid, gameareaid, appareaid, status, gamename, createtime) values (111, 221, '111', '111', 1, '测试', to_date('2004-06-30','yyyy-mm-dd'));
6.SqlServer表字段如果设置了默认值,那么就必须要设置这个字段为非空