debug sql with parameters
-
Hi, i use VS2008 and SQLServer 2005. How can i debug a sql-statement, that includes parameters like this ?
string sqlstatement = "INSERT INTO artikel (nr,text1,text2)" +
"VALUES" +
"( @parm1, " +
" @parm2, " +
" @parm3 " +
" " +
" )";
SqlCommand sqlins = new SqlCommand(sqlstatement, con);
sqlins.Parameters.Add("@parm1", SqlDbType.NVarChar).Value = var1;
sqlins.Parameters.Add("@parm2", SqlDbType.Int).Value = var2;
sqlins.Parameters.Add("@parm3", SqlDbType.Int).Value = var3;
sqlins.ExecuteNonQuery();so, how can i see the statement, that will be sent to the sql-server ? bye jogi
-
Hi, i use VS2008 and SQLServer 2005. How can i debug a sql-statement, that includes parameters like this ?
string sqlstatement = "INSERT INTO artikel (nr,text1,text2)" +
"VALUES" +
"( @parm1, " +
" @parm2, " +
" @parm3 " +
" " +
" )";
SqlCommand sqlins = new SqlCommand(sqlstatement, con);
sqlins.Parameters.Add("@parm1", SqlDbType.NVarChar).Value = var1;
sqlins.Parameters.Add("@parm2", SqlDbType.Int).Value = var2;
sqlins.Parameters.Add("@parm3", SqlDbType.Int).Value = var3;
sqlins.ExecuteNonQuery();so, how can i see the statement, that will be sent to the sql-server ? bye jogi
The parameters don't get substitued and then sent to SQL Server. Your statement gets sent and the parameters supplied seperately, SQL server then does the 'substitution'. It allows it to work more efficiently that way. So, not sure you can.
Regards, Rob Philpott.
-
Hi, i use VS2008 and SQLServer 2005. How can i debug a sql-statement, that includes parameters like this ?
string sqlstatement = "INSERT INTO artikel (nr,text1,text2)" +
"VALUES" +
"( @parm1, " +
" @parm2, " +
" @parm3 " +
" " +
" )";
SqlCommand sqlins = new SqlCommand(sqlstatement, con);
sqlins.Parameters.Add("@parm1", SqlDbType.NVarChar).Value = var1;
sqlins.Parameters.Add("@parm2", SqlDbType.Int).Value = var2;
sqlins.Parameters.Add("@parm3", SqlDbType.Int).Value = var3;
sqlins.ExecuteNonQuery();so, how can i see the statement, that will be sent to the sql-server ? bye jogi
Run a trace in SQL Profiler
-
Run a trace in SQL Profiler
-
SQL Profiler is an application contanined in SQL Server 2005 client tools. You will probably find it installed on your database server, you can also install it on your development machine. With it you can trace queries made on your database. For reference, look here.