Get_Search_Sql_Head = "Select Top 1 0 as RefreshFileSaveType,'NS_news' as PageType,A.ID as OnlyID as RefreshID from FS_NS_News as A,FS_NS_NewsClass as B where A.ClassID=B.ClassID and A.isURL=0 and A.isdraft=0 and A.isRecyle=0 and A.isLock=0"
execute(Get_Search_Sql_Head)
以上代码中Select Top 1 0 as RefreshFileSaveType,'NS_news' as PageType具体是什么意思?急需了解,先谢谢了!
execute(Get_Search_Sql_Head)
以上代码中Select Top 1 0 as RefreshFileSaveType,'NS_news' as PageType具体是什么意思?急需了解,先谢谢了!
Select Top 1 0 as RefreshFileSaveType,'NS_news' as PageType把显示的结果用RefreshFileSaveType、PageType来代表字段
--取第一条记录,0 作为 RefreshFileSaveType 的值
Select Top 1 0 as RefreshFileSaveType,
--'NS_news' 是字段PageType的值
'NS_news' as PageType
这个RefreshFileSaveType别名代表哪个字段呢?
数据表里也没有这个'NS_news'字段呀?
'NS_news'是新字段PageType的值