sqlcommand

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

SqlCommand.ExecuteScalar - specify a particular data item

I have a Store开发者_开发技巧d Procedure which returns 10 columns of data. Using cmd.ExecuteScalar() returns the value of the 1st column from the 1st record.[详细]

2023-03-09 16:06 分类：问答
How to insert a c# datetime var into SQL Server

Here is the code: string ConnectionString= @\"Data Source=localhost\\SQLEXPRESS; Initial Catalog=notepad; Integrated Security=SSPI \";[详细]

2023-03-07 12:41 分类：问答
How do I bind SqlCommand Parameters when using XML field modify() in C#

I\'m having trouble escaping SQL for use in a XML field with the modify() function: example code: new SqlCommand(\"UPDATE Table \" +[详细]

2023-03-03 18:32 分类：问答
What does SqlCommand.Prepare() do and when should it be used? [duplicate]

This question already has answers here: Closed 10 years ago. Possible Duplicate: Pros and Cons of using SqlComm开发者_开发技巧and Prepare in C#?[详细]

2023-03-01 20:27 分类：问答
Must declare the scalar variable @param problem

Newbie alert! Error: Must declare the scalar variable \"@param2\". Must declare the scalar variable \"@param2\"[详细]

2023-03-01 06:09 分类：问答
Using SqlCommand with SP and without SP Parameteres but just Values in C#

Hi it\'s possible to use the SQLCommand to work wi开发者_如何学Goth Stored Procedures but without the need of specify the name of each parameter?[详细]

2023-02-28 21:26 分类：问答
Powershell help, how can I combine text files in a directory to one file?

I\'m new to powershell. I\'m trying to convert some of our database scripts to powershell scripts.开发者_开发技巧One thing we do in our script currently (DOS BATCH FILE) is use the Type command...[详细]

2023-02-27 11:34 分类：问答
Read in a txt file using sqlcmd?

Is it possible to read in a txt file using sqlcmd, to avoid needing to type every cell by hand? I\'ve been given a txt file with every table row on one line, and every column seperated by a comma. (a[详细]

2023-02-26 23:48 分类：问答
checkboxlist selection issue

There are 5 goals and 5 employees. Each goal can be assigned to any number of these 5 employees. So I have 5 CheckBoxLists for each of the goals, each CheckBoxList having the names of these 5 employee[详细]

2023-02-26 09:56 分类：问答
What are the limitations of T-SQL that can be executed by a System.Data.SqlClient.SqlCommand object?

I have some Transact-SQL that lloks like this, can it be executed through a SqlCommand object, or do I need to start learning Sql Management Objects?[详细]

2023-02-25 13:40 分类：问答