Top "Sqlcommand" questions

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database which is used in Microsoft .NET.

How to export and import a .sql file from command line with options?

Not Duplicate! looking for some feature have phpmyadmin during export in command line I want to export and import a .…

mysql command-line command-line-arguments sqlcommand
How to pass table value parameters to stored procedure from .net code

I have a SQL Server 2005 database. In a few procedures I have table parameters that I pass to a stored …

c# sql-server stored-procedures sqlcommand table-valued-parameters
Insert into C# with SQLCommand

What's the best way to INSERT data into a database? This is what I have but it's wrong.. cmd.CommandText = "…

c# .net ado.net sqlcommand
How to run multiple SQL commands in a single SQL connection?

I am creating a project in which I need to run 2-3 SQL commands in a single SQL connection. Here …

c# sql-server ado.net sqlconnection sqlcommand
How to clear mysql screen console in windows?

The title is my question. I googled and try something like mysql> !\ clear mysql> !\ cls mysql> system …

mysql windows command-line sqlcommand
Check if a record exists in the database

I am using these lines of code to check if the record exists or not. SqlCommand check_User_Name = new …

c# winforms sqlcommand
C# SQL insert command

Can anyone tell me the following 2 ways of inserting record creates better performance? Case 1 SqlCommand cmd = new SqlCommand(); for (int …

c# sql loops insert sqlcommand
SqlCommand Parameters Add vs. AddWithValue

When should I use Parameters. Add/AddWithValue? In the following MSDN example they use Parameters.Add for int and Parameters.…

c# parameters sqlcommand
Check if record in a table exist in a database through ExecuteNonQuery

in my program i need to check if a record in the database already exists in the table using the …

c# sqlcommand