sqlcommand

相关标签：javascript jquery android 多少钱 iPhone

Insert with select subquery using SqlCommand

I am having a problem when using an INSERT statement with a nested select. The query works when executing it in the SQLManagement Studio but returns an error when executing it in code.[详细]

2023-01-15 11:29 分类：问答
SqlCommand-class force SELECT only?

I\'m developing a application that\'s for SQL-surveillance, it\'s just a console application that will run each 5min on a bunch of servers. It has a config file with connection string and sql query. T[详细]

2023-01-14 19:29 分类：问答
.Net SQLCommand times out when executing Stored Procedure which returns no records

I wonder if any one may be able to help? I have an issue with a SqlCommand object that when it executes a stored procedure that returns no records, will timeout.[详细]

2023-01-12 10:13 分类：问答
Which pattern is better for SqlConnection object?

Which pattern is better for SqlConnection object? Which is better in performance? Do you offer any other pattern?[详细]

2023-01-09 22:22 分类：问答
How does dotNet handle parameterised dates where programmatic date has no time but sql date has time

Dreadful title right? Thought I\'d see if Stack overflow is quicker than me testing something while I get a thousand interruptions from other work :)[详细]

2023-01-07 19:43 分类：问答
What SqlCommand.Parameters.AddWithValue really does?

What changes SqlCommand.Parameters.AddWithValue() does with the query? I expect that: It replaces e开发者_开发知识库very \' character by \'\',[详细]

2023-01-07 06:09 分类：问答
Calling sqlCommand in a loop increasing exec time every step

I\'ve got a loop that executes the stored procedure in a loop with over 40,000 iterations, like so: SqlCommand command = new SqlCommand(\"WriteDataToDB\");[详细]

2023-01-06 01:33 分类：问答
Select most frequent from column in

Hi i have a columm in the table and i want to select the most common item from the selected column. The table is set up[详细]

2023-01-04 16:50 分类：问答
SqlCommand.Dispose() not disposing the SqlParameters in it - Memory Leak - C#.NET

I\'ve a windows forms application with MS SQL Server 2005 as the back end. I have written code in the form to call few stored procedures using SqlConnection, SqlCommand objects and i properly dispose[详细]

2023-01-03 09:27 分类：问答
What value should .net SqlCommand.ExecuteNonQuery() return if no rows are affected?

I have the following code: int result = -1; StringBuilder sb = new StringBuilder(); SqlCommand cmd = MyConnection.[详细]

2023-01-01 01:39 分类：问答