期望值关于概率参数的性质# Economics - 经济
m*n
1 楼
最近所有的数据从Access转到了SQL Server,很多.asp里的“select”语句需要做相应
的改动,但是到底要改多少?
比方下面的第一段里“ CategoryName <> """" ”肯定得改成“ CategoryName is not
null ”,可是left join - on,需要改成where-and吗?
还有第二段里 strQ = strQ & "WHERE [RQ].NomID = "
strQ = strQ & NomID
strQ = strQ & " "
是啥意思?之前没写过asp,语法上不太明白,因为如果纯sql的话,直接strQ = strQ &
"AND [RQ].NomID = NomID "就可以了,为什么要写成3行?
哪个高人顺手帮我改改,让我有个例子好学习学习,谢啦
strQuery = "SELECT DISTINCT NominationCategories.CategoryID,
CategoryName, Weight " & _
"FROM (NominationDetailsCurrent LEFT JOIN NominationCategories
ON NominationCategories.NomID = NominationDetailsCurrent.NomID) LEFT
JOIN Categories ON NominationCategories.CategoryID =
Categories.CategoryID " & _
"WHERE CategoryName <> """" " & _
"ORDER BY Weight"
strQ = "SELECT [Q].QuestionID, [Q].Title, [Q].Description,
[Q].Question, [Q].Type, [Q].Required "
strQ = strQ & "FROM Questions AS [Q] INNER JOIN
NominationReplacementQuestions [RQ] "
strQ = strQ & "ON [RQ].QuestionID = [Q].QuestionID "
strQ = strQ & "WHERE [RQ].NomID = "
strQ = strQ & NomID
strQ = strQ & " "
strQ = strQ & "ORDER BY [Q].Order "
的改动,但是到底要改多少?
比方下面的第一段里“ CategoryName <> """" ”肯定得改成“ CategoryName is not
null ”,可是left join - on,需要改成where-and吗?
还有第二段里 strQ = strQ & "WHERE [RQ].NomID = "
strQ = strQ & NomID
strQ = strQ & " "
是啥意思?之前没写过asp,语法上不太明白,因为如果纯sql的话,直接strQ = strQ &
"AND [RQ].NomID = NomID "就可以了,为什么要写成3行?
哪个高人顺手帮我改改,让我有个例子好学习学习,谢啦
strQuery = "SELECT DISTINCT NominationCategories.CategoryID,
CategoryName, Weight " & _
"FROM (NominationDetailsCurrent LEFT JOIN NominationCategories
ON NominationCategories.NomID = NominationDetailsCurrent.NomID) LEFT
JOIN Categories ON NominationCategories.CategoryID =
Categories.CategoryID " & _
"WHERE CategoryName <> """" " & _
"ORDER BY Weight"
strQ = "SELECT [Q].QuestionID, [Q].Title, [Q].Description,
[Q].Question, [Q].Type, [Q].Required "
strQ = strQ & "FROM Questions AS [Q] INNER JOIN
NominationReplacementQuestions [RQ] "
strQ = strQ & "ON [RQ].QuestionID = [Q].QuestionID "
strQ = strQ & "WHERE [RQ].NomID = "
strQ = strQ & NomID
strQ = strQ & " "
strQ = strQ & "ORDER BY [Q].Order "