查询是期望像“）”这样的符号。

本文介绍了查询是期望像“）”这样的符号。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 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 解决方案 试试这个： 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 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_stampFROM 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_stampFROM ETL_Files AS EF INNER JOINDataProviders AS DP ON DP.ID = EF.DataProviderID INNER JOINDataCategories AS DC ON DC.ID = EF.DataCategoryID INNER JOINClients AS C ON C.ID = 1 INNER JOINETL_FileStages AS EFS ON EFS.ID = EF.FileStage WHERE CONVERT(date,dtTimeStamp,101) = '2014-10-30' ORDER BY Time_stamp DESC 这篇关于查询是期望像“）”这样的符号。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！