查询是期望像“）”这样的符号。 [英] Query was Expecting symbol like ")"

问题描述

SELECT EF.ID，EF.FileName，EF.IsOnboarding，DP.Name AS DataProviderName，DC.Name AS DataCategoryName，C.Name AS ClientName，EFS.Name AS FileStageName，

EF。 FileStatus，EF.HasError，EF.UploadedOn，EF.UploadedBy，EF.dtTimeStamp AS Time_stamp

FROM ETL_Files AS EF INNER JOIN

DataProviders AS DP ON DP.ID = EF .DataProviderID INNER JOIN

DataCategories AS DC ON DC.ID = EF.DataCategoryID INNER JOIN

客户AS C ON C.ID = 1 INNER JOIN

ETL_FileStages AS EFS ON EFS.ID = EF.FileStage WHERE（CONVERT（date，dtTimeStamp，101）='2014-10-30'ORDER BY Time_stamp DESC

解决方案

< blockquote>试试这个：

  SELECT  EF.ID，EF.FileName，EF.IsOnboarding，DP。名称 AS  DataProviderName，DC.Name  AS  DataCategoryName，C.Name  AS  ClientName，EFS.Name  AS  FileStageName，
 EF.FileStatus，EF.HasError，EF.UploadedOn，EF.UploadedBy，EF.dtTimeStamp  AS  Time_stamp 
  FROM  ETL_Files  AS  EF  INNER   JOIN  
 DataProviders  AS  DP  ON  DP.ID = EF.DataProviderID  INNER   JOIN  
 DataCategories  AS  DC  ON  DC.ID = EF.DataCategoryID  INNER   JOIN  
客户 AS  C  ON  C.ID =  1   INNER   JOIN  
 ETL_FileStages  AS  EFS < span class =code-keyword> ON  EFS.ID = EF.FileStage  WHERE   CONVERT （ date ，dtTimeStamp， 101 ）= '  2014-10-30'  ORDER   BY  Time_stamp  DESC  

SELECT EF.ID, EF.FileName, EF.IsOnboarding, DP.Name AS DataProviderName, DC.Name AS DataCategoryName, C.Name AS ClientName, EFS.Name AS FileStageName,
EF.FileStatus, EF.HasError, EF.UploadedOn, EF.UploadedBy, EF.dtTimeStamp AS Time_stamp
FROM ETL_Files AS EF INNER JOIN
DataProviders AS DP ON DP.ID = EF.DataProviderID INNER JOIN
DataCategories AS DC ON DC.ID = EF.DataCategoryID INNER JOIN
Clients AS C ON C.ID = 1 INNER JOIN
ETL_FileStages AS EFS ON EFS.ID = EF.FileStage WHERE (CONVERT(date,dtTimeStamp,101) = '2014-10-30' ORDER BY Time_stamp DESC

解决方案

Try this :

SELECT EF.ID, EF.FileName, EF.IsOnboarding, DP.Name AS DataProviderName, DC.Name AS DataCategoryName, C.Name AS ClientName, EFS.Name AS FileStageName,
EF.FileStatus, EF.HasError, EF.UploadedOn, EF.UploadedBy, EF.dtTimeStamp AS Time_stamp
FROM ETL_Files AS EF INNER JOIN
DataProviders AS DP ON DP.ID = EF.DataProviderID INNER JOIN
DataCategories AS DC ON DC.ID = EF.DataCategoryID INNER JOIN
Clients AS C ON C.ID = 1 INNER JOIN
ETL_FileStages AS EFS ON EFS.ID = EF.FileStage WHERE CONVERT(date,dtTimeStamp,101) = '2014-10-30' ORDER BY Time_stamp DESC 

这篇关于查询是期望像“）”这样的符号。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！