Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here are some explanations:</p> <p><a href="http://forums.asp.net/t/1370191.aspx" rel="nofollow">difference between command Add and AddWithValue</a> </p> <pre><code>Dim cmd as new SqlCommand("SELECT * FROM MyTable WHERE MyDate&gt;@TheDate",conn) cmd.Parameters.Add("@TheDate",SqlDbType.DateTime).Value="2/1/2007" </code></pre> <p>vs</p> <pre><code>cmd.Parameters.AddWithValue("@TheDate","2/1/2007") </code></pre> <p>"Add forces the conversion from string to date as it goes into the parameter. AddWithValue would have simply passed the string on to the SQL Server.</p> <blockquote> <p>When using <code>Parameters.Add</code> - the S qlDbTypeis known at compile time </p> <p>When using <code>Parameters.AddWithValue</code> the method has to box and unbox the value to find out it's type.</p> <p>Additional benefits of the former is that <code>Add</code> is a bit more code safe and will assist against sql injection attacks , code safe in terms that if you try to pass a value that doesn't match the sqldb type defined - the error will be caught in .Net code and you will not have to wait for the round trip back.</p> </blockquote> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx</a></li> <li><a href="http://msdn.microsoft.com/en-us/library/yy6y35y8.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/yy6y35y8.aspx</a></li> </ul> <p><strong>Edit</strong>: </p> <p>example to get an Output-Parameter:</p> <p>C#</p> <pre><code>cmd.Parameters.Add(new SqlParameter("@TheNewId", SqlDbType.Int, int.MaxValue)); cmd.Parameters("@TheNewId").Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); int theNewID = (int)cmd.Parameters("@TheNewId").Value; </code></pre> <p>VB.Net</p> <pre><code>cmd.Parameters.Add(New SqlParameter("@TheNewId", SqlDbType.Int, Int32.MaxValue)) cmd.Parameters("@TheNewId").Direction = ParameterDirection.Output cmd.ExecuteNonQuery() Dim theNewID As Int32 = DirectCast(cmd.Parameters("@TheNewId").Value, Int32) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PODifference between adding parameters to stored procedure in SQL Server 2005
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTim Schmelter
    1. USTim Schmelter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODifference between adding parameters to stored procedure in SQL Server 2005
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CO@Tim so u mean both methods are used for passing parameters into stored procedure.
      singulars
      1. PO
      1. USSreedhar
    2. CO@user653622: Yes, but not only for stored-procedures but every kind of sql-command. They both have advantages and disadvantages(see links).
      singulars
      1. PO
      1. USTim Schmelter
    3. CO@Tim How can I use the second method for passing output type parameters especially when I won't have any value to pass but instead I would be expecting a value from stored procedure. Specifically in this case cmd2.Parameters.Add("@TheNewId", SqlDbType.Int).Value = ???; If i use the second method it would be expecting a value but i have to tell it explicitly don't expect a value u r a output parameter, how should i tell this ? Please help me
      singulars
      1. PO
      1. USSreedhar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload