6publicstaticboolDataBackupConfigDB(stringbackupFolder) 7{ 8//获取配置文件中sql数据库名 9stringdbName="SqlDB"; 10stringname=dbName+DateTime.Now.ToString("yyyyMMddHHmmss"); 11stringprocname; 12stringsql; 13//创建连接对象 14SqlConnection conn=newSqlConnection(GetConnStr()); 15conn.Open();//打开...
status, string remark, DateTime? startTime, DateTime? endTime) { var session = LiteSqlFactory.GetSession(); ISqlString sql = session.CreateSql(@" select t.*, u.real_name as OrderUserRealName from bs_order t left join sys_user u on t.order_userid=u.id where 1=1"); sql.AppendIf...
Assign empty string '' if datetime is null Assign EXEC output to Variable Assigning NULL value to column name using Case Statement of where is SQL SERVER 2008 atomic if not exists() and insert or update Attempt to fetch logical page (1:155534) in database 7 failed. It belongs to allocati...
status, string remark, DateTime? startTime, DateTime? endTime) { var session = LiteSqlFactory.GetSession(); ISqlString sql = session.CreateSql(@" select t.*, u.real_name as OrderUserRealName from bs_order t left join sys_user u on t.order_userid=u.id where 1=1"); sql.AppendIf...
status, string remark, DateTime? startTime, DateTime? endTime) { var session = DapperLiteFactory.GetSession(); ISqlString sql = session.Sql(@" select t.*, u.real_name as OrderUserRealName from bs_order t left join sys_user u on t.order_userid=u.id where 1=1"); sql.AppendIf(...