八度空间

摘要： SqlConnection conn = new SqlConnection();conn.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["connstr"].Trim();SqlCommand comm = new SqlCommand(); comm.Connection = conn; com... 阅读全文

摘要： declare @id intdeclare @name varchar(20)declare @str varchar(1000)set @id=''set @name=''select @id=[8dgsUser_ID],@name=[8dgsUser_Name] from [8dgsUser] where [8dgsUser_ID]=2print(@id)print(@name)这样就可以获... 阅读全文

摘要： 方法1：IF @aaa = 1BEGIN END ELSE IF @aaa = 2BEGIN END 方法2：SELECT * , (CASE WHEN 积分列 >100 THEN '【一级会员】' WHEN 积分列 >100 THEN '【二级会员】' WHEN 积分列 >100 THEN '【三级会员】' ELSE '【普通会员】' END) 会员等级 FROM 表名 阅读全文