c# - LINQ 查询速度慢，创建超时；生成的 SQL 没问题？-6ren

c# - LINQ 查询速度慢，创建超时；生成的 SQL 没问题？

转载作者：行者123 更新时间：2023-11-30 23:22:19

我有一个相当复杂的 LINQ 查询，它通常很慢，它创建了一个 System.Data.SqlClient.SqlException : "等待操作超时"。

但是，当我记录生成的 SQL(通过将 TextWriter 分配给 DataContext 的 Log )，并直接在 SQL Server 上执行时，它在大约 4 秒内完成，这很好。

差异从何而来，如何调试？

编辑:我还注意到，在 Sql Server Management Studio 的事件监视器中，当从 .NET 执行查询时，处理器时间飙升至 100%，但当我执行生成的 SQL 查询时，处理器时间仅为 3% 左右。

我不确定发布我的代码会有什么帮助，但由于有人要求，这里是包含查询的代码:

var Db = MyProject.GetDataContext();
var statusPaymentSuccess = new string[] { "SUCCESS", "REMBOURS", "AFTERPAY" };

var items = Db.Orders.Where(item =>
    (siteid == null || item.SiteId == siteid) &&
    (ls_list.Contains(item.OrderOrderLifeCycles.OrderByDescending(it => it.Id).First().OrderLifeCycleId)) &&
    (item.OrderOrderPaymentStatus.Any(ops => statusPaymentSuccess.Contains(ops.OrderPaymentStatus.Code)) &&
        (CycleID == null || item.OrderOrderLifeCycles.First().OrderLifeCycleId == CycleID) &&
        (LocationID == null || item.SaleLocationId == LocationID) &&
        (string.IsNullOrEmpty(SalesPerson) || item.EmployeeName.ToLower() == SalesPerson.ToLower()))
);

var betweenorders = items.Select(it => new OrderBetween()
{
    FirstPayDate = it.OrderOrderPaymentStatus.FirstOrDefault(ops => statusPaymentSuccess.Contains(ops.OrderPaymentStatus.Code)).DateTime,
    OrderTotal = it.TotalAmount,
    VatTotal = it.OrderItems.Sum(it2 => it2.BTWAmount ?? 0),
    Quantity = it.OrderItems.Count,
    SiteId = it.SiteId
});

return betweenorders.Where(item => item.FirstPayDate >= start && item.FirstPayDate < stop)
    .GroupBy(item => item.FirstPayDate.Value.Year + "-" + item.FirstPayDate.Value.Month).Select(
        item =>
            new SaleTotal()
            {
                Count = item.Sum(sub => sub.Quantity),
                Month = item.FirstOrDefault().FirstPayDate.Value.Year + "-" + item.FirstOrDefault().FirstPayDate.Value.Month.ToString().PadLeft(2, '0'),
                Total = item.Sum(sub => sub.OrderTotal),
                VAT = item.Sum(sub => sub.VatTotal)
            }).OrderBy(item => item.Month).ToArray();

哪里ls_list是 List<int>包含 OrderOrderLifeCycles ID。

从日志中提取的生成的 SQL 查询:

DECLARE @p0 NVarChar(4000) = 'SUCCESS' 
DECLARE @p1 NVarChar(4000) = 'REMBOURS' 
DECLARE @p2 NVarChar(4000) = 'AFTERPAY' 
DECLARE @p3 Decimal(31,2) = '0' 
DECLARE @p4 NVarChar(4000) = '-' 
DECLARE @p5 DateTime = '2016-06-01' 
DECLARE @p6 DateTime = '2016-09-01' 
DECLARE @p7 Int = '4' 
DECLARE @p8 Int = '5' 
DECLARE @p9 Int = '8' 
DECLARE @p10 NVarChar(4000) = 'SUCCESS' 
DECLARE @p11 NVarChar(4000) = 'REMBOURS' 
DECLARE @p12 NVarChar(4000) = 'AFTERPAY' 
DECLARE @p13 NVarChar(4000) = '-' 
DECLARE @p14 NVarChar(4000) = '-' 
DECLARE @p15 Int = '2' 
DECLARE @p16 NChar(1) = '0' 
SELECT [t64].[value] AS [Month], [t64].[value2] AS [Count], [t64].[value22] AS [Total], [t64].[value3] AS [VAT]
FROM (
    SELECT ((CONVERT(NVarChar,DATEPART(Year, (
        SELECT [t23].[value]
        FROM (
            SELECT TOP (1) [t18].[value]
            FROM (
                SELECT (
                    SELECT [t17].[DateTime]
                    FROM (
                        SELECT TOP (1) [t15].[DateTime]
                        FROM [dbo].[OrderOrderPaymentStatus] AS [t15]
                        INNER JOIN [dbo].[OrderPaymentStatus] AS [t16] ON [t16].[Id] = [t15].[OrderPaymentStatusId]
                        WHERE ([t16].[Code] IN (@p0, @p1, @p2)) AND ([t15].[OrderId] = [t14].[Id])
                        ) AS [t17]
                    ) AS [value], [t14].[Id]
                FROM [dbo].[Order] AS [t14]
                ) AS [t18]
            WHERE ((([t13].[value4] IS NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t18].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t18].[value])))) IS NULL)) OR (([t13].[value4] IS NOT NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t18].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t18].[value])))) IS NOT NULL) AND ([t13].[value4] = (((CONVERT(NVarChar,DATEPART(Year, [t18].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t18].[value]))))))) AND ([t18].[value] >= @p5) AND ([t18].[value] < @p6) AND (((
                SELECT [t20].[OrderLifeCycleId]
                FROM (
                    SELECT TOP (1) [t19].[OrderLifeCycleId]
                    FROM [dbo].[OrderOrderLifeCycle] AS [t19]
                    WHERE [t19].[OrderId] = [t18].[Id]
                    ORDER BY [t19].[Id] DESC
                    ) AS [t20]
                )) IN (@p7, @p8, @p9)) AND (EXISTS(
                SELECT NULL AS [EMPTY]
                FROM [dbo].[OrderOrderPaymentStatus] AS [t21]
                INNER JOIN [dbo].[OrderPaymentStatus] AS [t22] ON [t22].[Id] = [t21].[OrderPaymentStatusId]
                WHERE ([t22].[Code] IN (@p10, @p11, @p12)) AND ([t21].[OrderId] = [t18].[Id])
                ))
            ) AS [t23]
        )))) + @p14) + (
        (CASE 
            WHEN (CONVERT(Int,DATALENGTH(CONVERT(NVarChar,DATEPART(Month, (
                SELECT [t63].[value]
                FROM (
                    SELECT TOP (1) [t58].[value]
                    FROM (
                        SELECT (
                            SELECT [t57].[DateTime]
                            FROM (
                                SELECT TOP (1) [t55].[DateTime]
                                FROM [dbo].[OrderOrderPaymentStatus] AS [t55]
                                INNER JOIN [dbo].[OrderPaymentStatus] AS [t56] ON [t56].[Id] = [t55].[OrderPaymentStatusId]
                                WHERE ([t56].[Code] IN (@p0, @p1, @p2)) AND ([t55].[OrderId] = [t54].[Id])
                                ) AS [t57]
                            ) AS [value], [t54].[Id]
                        FROM [dbo].[Order] AS [t54]
                        ) AS [t58]
                    WHERE ((([t13].[value4] IS NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NULL)) OR (([t13].[value4] IS NOT NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NOT NULL) AND ([t13].[value4] = (((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value]))))))) AND ([t58].[value] >= @p5) AND ([t58].[value] < @p6) AND (((
                        SELECT [t60].[OrderLifeCycleId]
                        FROM (
                            SELECT TOP (1) [t59].[OrderLifeCycleId]
                            FROM [dbo].[OrderOrderLifeCycle] AS [t59]
                            WHERE [t59].[OrderId] = [t58].[Id]
                            ORDER BY [t59].[Id] DESC
                            ) AS [t60]
                        )) IN (@p7, @p8, @p9)) AND (EXISTS(
                        SELECT NULL AS [EMPTY]
                        FROM [dbo].[OrderOrderPaymentStatus] AS [t61]
                        INNER JOIN [dbo].[OrderPaymentStatus] AS [t62] ON [t62].[Id] = [t61].[OrderPaymentStatusId]
                        WHERE ([t62].[Code] IN (@p10, @p11, @p12)) AND ([t61].[OrderId] = [t58].[Id])
                        ))
                    ) AS [t63]
                )))) / 2)) >= @p15 THEN CONVERT(NVarChar,DATEPART(Month, (
                SELECT [t63].[value]
                FROM (
                    SELECT TOP (1) [t58].[value]
                    FROM (
                        SELECT (
                            SELECT [t57].[DateTime]
                            FROM (
                                SELECT TOP (1) [t55].[DateTime]
                                FROM [dbo].[OrderOrderPaymentStatus] AS [t55]
                                INNER JOIN [dbo].[OrderPaymentStatus] AS [t56] ON [t56].[Id] = [t55].[OrderPaymentStatusId]
                                WHERE ([t56].[Code] IN (@p0, @p1, @p2)) AND ([t55].[OrderId] = [t54].[Id])
                                ) AS [t57]
                            ) AS [value], [t54].[Id]
                        FROM [dbo].[Order] AS [t54]
                        ) AS [t58]
                    WHERE ((([t13].[value4] IS NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NULL)) OR (([t13].[value4] IS NOT NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NOT NULL) AND ([t13].[value4] = (((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value]))))))) AND ([t58].[value] >= @p5) AND ([t58].[value] < @p6) AND (((
                        SELECT [t60].[OrderLifeCycleId]
                        FROM (
                            SELECT TOP (1) [t59].[OrderLifeCycleId]
                            FROM [dbo].[OrderOrderLifeCycle] AS [t59]
                            WHERE [t59].[OrderId] = [t58].[Id]
                            ORDER BY [t59].[Id] DESC
                            ) AS [t60]
                        )) IN (@p7, @p8, @p9)) AND (EXISTS(
                        SELECT NULL AS [EMPTY]
                        FROM [dbo].[OrderOrderPaymentStatus] AS [t61]
                        INNER JOIN [dbo].[OrderPaymentStatus] AS [t62] ON [t62].[Id] = [t61].[OrderPaymentStatusId]
                        WHERE ([t62].[Code] IN (@p10, @p11, @p12)) AND ([t61].[OrderId] = [t58].[Id])
                        ))
                    ) AS [t63]
                )))
            ELSE REPLICATE(@p16, @p15 - (CONVERT(Int,DATALENGTH(CONVERT(NVarChar,DATEPART(Month, (
                SELECT [t63].[value]
                FROM (
                    SELECT TOP (1) [t58].[value]
                    FROM (
                        SELECT (
                            SELECT [t57].[DateTime]
                            FROM (
                                SELECT TOP (1) [t55].[DateTime]
                                FROM [dbo].[OrderOrderPaymentStatus] AS [t55]
                                INNER JOIN [dbo].[OrderPaymentStatus] AS [t56] ON [t56].[Id] = [t55].[OrderPaymentStatusId]
                                WHERE ([t56].[Code] IN (@p0, @p1, @p2)) AND ([t55].[OrderId] = [t54].[Id])
                                ) AS [t57]
                            ) AS [value], [t54].[Id]
                        FROM [dbo].[Order] AS [t54]
                        ) AS [t58]
                    WHERE ((([t13].[value4] IS NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NULL)) OR (([t13].[value4] IS NOT NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NOT NULL) AND ([t13].[value4] = (((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value]))))))) AND ([t58].[value] >= @p5) AND ([t58].[value] < @p6) AND (((
                        SELECT [t60].[OrderLifeCycleId]
                        FROM (
                            SELECT TOP (1) [t59].[OrderLifeCycleId]
                            FROM [dbo].[OrderOrderLifeCycle] AS [t59]
                            WHERE [t59].[OrderId] = [t58].[Id]
                            ORDER BY [t59].[Id] DESC
                            ) AS [t60]
                        )) IN (@p7, @p8, @p9)) AND (EXISTS(
                        SELECT NULL AS [EMPTY]
                        FROM [dbo].[OrderOrderPaymentStatus] AS [t61]
                        INNER JOIN [dbo].[OrderPaymentStatus] AS [t62] ON [t62].[Id] = [t61].[OrderPaymentStatusId]
                        WHERE ([t62].[Code] IN (@p10, @p11, @p12)) AND ([t61].[OrderId] = [t58].[Id])
                        ))
                    ) AS [t63]
                )))) / 2))) + (CONVERT(NVarChar,DATEPART(Month, (
                SELECT [t63].[value]
                FROM (
                    SELECT TOP (1) [t58].[value]
                    FROM (
                        SELECT (
                            SELECT [t57].[DateTime]
                            FROM (
                                SELECT TOP (1) [t55].[DateTime]
                                FROM [dbo].[OrderOrderPaymentStatus] AS [t55]
                                INNER JOIN [dbo].[OrderPaymentStatus] AS [t56] ON [t56].[Id] = [t55].[OrderPaymentStatusId]
                                WHERE ([t56].[Code] IN (@p0, @p1, @p2)) AND ([t55].[OrderId] = [t54].[Id])
                                ) AS [t57]
                            ) AS [value], [t54].[Id]
                        FROM [dbo].[Order] AS [t54]
                        ) AS [t58]
                    WHERE ((([t13].[value4] IS NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NULL)) OR (([t13].[value4] IS NOT NULL) AND ((((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value])))) IS NOT NULL) AND ([t13].[value4] = (((CONVERT(NVarChar,DATEPART(Year, [t58].[value]))) + @p13) + (CONVERT(NVarChar,DATEPART(Month, [t58].[value]))))))) AND ([t58].[value] >= @p5) AND ([t58].[value] < @p6) AND (((
                        SELECT [t60].[OrderLifeCycleId]
                        FROM (
                            SELECT TOP (1) [t59].[OrderLifeCycleId]
                            FROM [dbo].[OrderOrderLifeCycle] AS [t59]
                            WHERE [t59].[OrderId] = [t58].[Id]
                            ORDER BY [t59].[Id] DESC
                            ) AS [t60]
                        )) IN (@p7, @p8, @p9)) AND (EXISTS(
                        SELECT NULL AS [EMPTY]
                        FROM [dbo].[OrderOrderPaymentStatus] AS [t61]
                        INNER JOIN [dbo].[OrderPaymentStatus] AS [t62] ON [t62].[Id] = [t61].[OrderPaymentStatusId]
                        WHERE ([t62].[Code] IN (@p10, @p11, @p12)) AND ([t61].[OrderId] = [t58].[Id])
                        ))
                    ) AS [t63]
                ))))
         END)) AS [value], [t13].[value] AS [value2], [t13].[value2] AS [value22], [t13].[value3]
    FROM (
        SELECT SUM([t8].[value3]) AS [value], SUM([t8].[TotalAmount]) AS [value2], SUM([t8].[value22]) AS [value3], [t8].[value] AS [value4]
        FROM (
            SELECT ((CONVERT(NVarChar,DATEPART(Year, [t7].[value]))) + @p4) + (CONVERT(NVarChar,DATEPART(Month, [t7].[value]))) AS [value], [t7].[value] AS [value2], [t7].[Id], [t7].[value3], [t7].[TotalAmount], [t7].[value2] AS [value22]
            FROM (
                SELECT (
                    SELECT [t3].[DateTime]
                    FROM (
                        SELECT TOP (1) [t1].[DateTime]
                        FROM [dbo].[OrderOrderPaymentStatus] AS [t1]
                        INNER JOIN [dbo].[OrderPaymentStatus] AS [t2] ON [t2].[Id] = [t1].[OrderPaymentStatusId]
                        WHERE ([t2].[Code] IN (@p0, @p1, @p2)) AND ([t1].[OrderId] = [t0].[Id])
                        ) AS [t3]
                    ) AS [value], [t0].[TotalAmount], (
                    SELECT SUM([t5].[value])
                    FROM (
                        SELECT COALESCE([t4].[BTWAmount],@p3) AS [value], [t4].[OrderId]
                        FROM [dbo].[OrderItem] AS [t4]
                        ) AS [t5]
                    WHERE [t5].[OrderId] = [t0].[Id]
                    ) AS [value2], (
                    SELECT COUNT(*)
                    FROM [dbo].[OrderItem] AS [t6]
                    WHERE [t6].[OrderId] = [t0].[Id]
                    ) AS [value3], [t0].[Id]
                FROM [dbo].[Order] AS [t0]
                ) AS [t7]
            ) AS [t8]
        WHERE ([t8].[value2] >= @p5) AND ([t8].[value2] < @p6) AND (((
            SELECT [t10].[OrderLifeCycleId]
            FROM (
                SELECT TOP (1) [t9].[OrderLifeCycleId]
                FROM [dbo].[OrderOrderLifeCycle] AS [t9]
                WHERE [t9].[OrderId] = [t8].[Id]
                ORDER BY [t9].[Id] DESC
                ) AS [t10]
            )) IN (@p7, @p8, @p9)) AND (EXISTS(
            SELECT NULL AS [EMPTY]
            FROM [dbo].[OrderOrderPaymentStatus] AS [t11]
            INNER JOIN [dbo].[OrderPaymentStatus] AS [t12] ON [t12].[Id] = [t11].[OrderPaymentStatusId]
            WHERE ([t12].[Code] IN (@p10, @p11, @p12)) AND ([t11].[OrderId] = [t8].[Id])
            ))
        GROUP BY [t8].[value]
        ) AS [t13]
    ) AS [t64]
ORDER BY [t64].[value]

最佳答案

改进查询的一个明显方法在第一部分立即引起了人们的注意:

var items = Db.Orders.Where(item =>
    (siteid == null || item.SiteId == siteid)
 && (ls_list.Contains(item.OrderOrderLifeCycles.OrderByDescending(it => it.Id).First().OrderLifeCycleId))
 && (item.OrderOrderPaymentStatus.Any(ops => statusPaymentSuccess.Contains(ops.OrderPaymentStatus.Code))
 && (CycleID == null || item.OrderOrderLifeCycles.First().OrderLifeCycleId == CycleID)
 && (LocationID == null || item.SaleLocationId == LocationID)
 && (string.IsNullOrEmpty(SalesPerson) || item.EmployeeName.ToLower() == SalesPerson.ToLower()))
);

请记住，整个 LINQ 语句都被翻译成 SQL，包括所有这些 null 检查。这使得 SQL 查询变得不必要地复杂并且更难被查询优化器处理。 (顺便说一句，您展示了属于另一个 LINQ 语句的 SQL 查询)。

处理可空条件的推荐方法是编写查询:

IQueryable<Order> items = var items = Db.Orders;

if(siteid != null)
{
    items = items.Where(item => item.SiteId == siteid);
}
if (CycleID != null)
{
    items = items.Where(item => item.OrderOrderLifeCycles.First().OrderLifeCycleId == CycleID);
}
// etc.

还有一点是

item.EmployeeName.ToLower() == SalesPerson.ToLower()

这会在应用搜索条件之前转换 EmployeeName 字段值。这意味着不能使用 EmployeeName 上的任何索引(也称为 not sargable)。我认为您可以删除 ToLower() 调用。在 SQL 查询中，使用了 EmployeeName 字段的数据库排序规则，默认情况下很可能不区分大小写 (CI)。

最后，你可以考虑执行分组...

GroupBy(item => item.FirstPayDate.Value.Year + "-" + item.FirstPayDate.Value.Month)

... 在内存中(LINQ to objects)而不是在数据库中。即:

return betweenorders.Where(item => item.FirstPayDate >= start && item.FirstPayDate < stop)
.AsEnumerable() // Switch to LINQ to objects
.GroupBy(...

分组被翻译为 ORDER BY(不是 GROUP BY，原因超出了这个答案的范围)，而且，数据库字段的转换 FirstPayDate 禁用索引。它还使 SQL 查询不那么复杂，并且在内存中执行此操作可能不是繁重的操作。

关于c# - LINQ 查询速度慢，创建超时；生成的 SQL 没问题？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/38828217/

文章推荐： python - 从文本字符串解析数据对象结构

文章推荐：具有整数分数的Mysql舍入特例

文章推荐： python - 无需修改第三方代码即可抑制警告

文章推荐： mysql - 从插入语句返回 Query_ID

sql - SQL、PL-SQL 和 T-SQL 之间有什么区别？
SQL、PL-SQL 和 T-SQL 之间有什么区别？谁能解释一下这三者之间的区别，并提供每一个的相关使用场景？最佳答案 SQL 是一种对集合进行操作的查询语言。它或多或少是标准化的，几乎所有关
sql - T-SQL、SQL Server 和 SQL 有什么区别
这个问题已经有答案了: What is the difference between SQL, PL-SQL and T-SQL? (6 个回答) 已关闭 9 年前。我对 SQL 的了解足以完成我的
sql - Linq To Sql - SQL 默认约束问题
我在数据库中有一个 USER 表。该表有一个 RegistrationDate 列，该列有一个默认约束为 GETDATE()。使用 LINQ 时，我没有为 RegistrationDate 列提供任
sql - 在字符串中查找第二组数字(SQL/PL-SQL)
我有一个可能属于以下类型的字符串 string expected result 15-th-rp 15 15/12-rp 12 15-12-th
sql - 服务器端 sql 与客户端 sql
很难说出这里问的是什么。这个问题模棱两可、含糊不清、不完整、过于宽泛或言辞激烈，无法以目前的形式合理回答。如需帮助澄清此问题以便可以重新打开，visit the help center . 9年前关闭
sql - sql 如何计算 sql 存储过程中的附加表？
我有一个存储过程(称为 sprocGetArticles)，它从文章表中返回文章列表。这个存储过程没有任何参数。用户可以对每篇文章发表评论，我将这些评论存储在由文章 ID 链接的评论表中。有什么方
sql - 嵌入式 SQL 与动态 SQL
我目前正在做一个 *cough*Oracle*cough* 数据库主题。讲师介绍embedded SQL作为让其他语言(例如 C、C++)与(Oracle)数据库交互的方式。我自己做了一些数据库工作
sql - SQL Server SQL 语句可以有多少个字符？
SQL Server 中 SQL 语句的最大长度是多少？这个长度是否取决于 SQL Server 的版本？例如，在 DECLARE @SQLStatement NVARCHAR(MAX) = N'S
sql-server - SQL 行到列 sql
这个问题已经有答案了: Simple way to transpose columns and rows in SQL? (9 个回答) 已关闭 8 年前。 CallType
sql - SQL Server SQL 语句中的动态日期
预先感谢您对此提供的任何帮助。假设我有一个查询，可以比较跨年的数据，从某个任意年份开始，永无止境(进入 future )，每年同一时期直到最后一个完整的月份(其特点是一月数据永远不会显示至 2 月
sql - Linq To Sql - SQL 默认约束问题
我在数据库中有一个 USER 表。该表有一个 RegistrationDate 列，该列的默认约束为 GETDATE()。使用 LINQ 时，我没有为 RegistrationDate 列提供任何数
sql - (SQL Server) SQL 不允许在检查过程是否存在后创建过程
下面是我试图用来检查存储过程是否不存在然后创建过程的 sql。它会抛出一个错误:Incorrect syntax near the keyword 'PROCEDURE' IF NOT EXISTS
sql - 动态 SQL 是否比 SQL Server 中的静态 SQL 性能更高？
我有一个同事声称动态 SQL 在许多情况下比静态 SQL 执行得更快，所以我经常看到 DSQL 到处都是。除了明显的缺点，比如在运行之前无法检测到错误并且更难阅读，这是否准确？当我问他为什么一直使用
sql - exec sp_executesql @sql 和 exec (@sql) SQL Server
来自 lobodava 的动态 SQL 查询是: declare @sql nvarchar(4000) = N';with cteColumnts (ORDINAL_POSITION, CO
sql - 动态 SQL - EXEC(@SQL) 与 EXEC SP_EXECUTESQL(@SQL)
使用 SQL Server 中的存储过程执行动态 SQL 命令的现实优点和缺点是什么 EXEC (@SQL) 对比 EXEC SP_EXECUTESQL @SQL ？最佳答案 sp_executes
c# - SQL > Linq to Sql，SQL 查询有效，Linq to SQL 返回空数据集
我有这个有效的 SQL 查询: select sum(dbos.Points) as Points, dboseasons.Year from dbo.StatLines dbos i
sql-server - "> sql.txt && sql -h-1 -i sql.txt && del sql.txt"命令是什么意思？
我正在调试一些构建成功运行的 SQL 命令的代码。然而，在查询结束时，查询结果似乎被写入了一个文本文件。完整的查询如下 echo SELECT DATE,DATETABLE,DATE,APPDAT
sql - 如何从 MS SQL 数据库(Microsoft SQL Server)中的其他 .sql 文件运行 .sql 文件？
我有一些创建表的 .sql 文件(MS SQL 数据库): 表_1.sql: IF OBJECT_ID (N'my_schema.table1', N'U') IS NOT NULL DROP TAB
sql - 如何在查询中使用 SQL 变量(SQL Server)？
我写了下面的 SQL 存储过程，它一直给我错误@pid = SELECT MAX(... 整个过程是: Alter PROCEDURE insert_partyco @pname varchar(20
sql - 如何将两个列表转换为邻接矩阵 SQL Server T-SQL？
我在 SQL Server 2005 中有包含两列 Fruit 和 Color 的表，如下所示 Fruit Colour Apple Red Orange

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

c# - LINQ 查询速度慢，创建超时；生成的 SQL 没问题？