八度空間

摘要： 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 表名 閱讀全文