A SELECT statement that assigns a value to a variable must ... (向變數賦值的 SELECT 語句不能與資料檢索操作結合使用 )...

iteye_20954發表於2011-12-09
[錯誤 ] select @classname=classname,@chargeteacher from classes where classid=@classid

[ 正確 ] select @classname=classname,@chargeteacher=chargeteacher from classes where classid=@classid


全部都應該是"賦值語句"才是正確的




相關文章