摘要： strSQL = "exec daycount " + Session("grade") + ",'" + Session("police") + "','" + AToDay + "'"CREATE Procedure daycount@Grad int,@police Varchar(10),@currenttime varchar(20)asif @Grad=0beginselect (se... 阅读全文

摘要： 1.按姓氏笔画排序:Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 2.数据库加密:select encrypt('原始密码')select pwdencrypt('原始密码')select pwdcompare('原始密码','加密后密码') = 1--相同；否则不相同3.取回表中字段:... 阅读全文