No announcements
Found 2837032 threads
-
0 VotesMust Declare a scalar value
adpter1.SelectCommand.Parameters.AddWithValue("@id",id); More details you can refer to this link. [Unanswered | 1 Replies | 796 Views | Created by oseedeqi - Monday, December 23, 2019 5:20 AM | Last reply by Daniel_Zhang-MSFT - Monday, December 23, 2019 10:01 AM
-
0 Votes
errors "Incorrect syntax near ']'.", "Invalid column name" and "Must declare teh scalar variable"
"Must declare the scalar variable "@UserNa" where the insert statement has variable of insert value as "@UserName.Unanswered | 2 Replies | 3099 Views | Created by Blueplane - Monday, October 6, 2008 6:04 PM | Last reply by VMazur - Monday, October 6, 2008 7:56 PM -
0 Votes
Execute SQL task "Must declare the scalar variable "@"
;Must declare the scalar variable "@" Regards, Navin Navin.D http://dnavin.wordpress.comAnswered | 1 Replies | 4428 Views | Created by Navind - Tuesday, May 22, 2012 7:29 AM | Last reply by Navind - Tuesday, May 22, 2012 7:44 AM -
1 Votes
Incorrect syntax near function, must declare the scalar variable "@Name", a RETURN statement with a return value cannot be used in this context
Incorrect syntax near function, must declare the scalar variable "@Name", a RETURN statement with a return ...Answered | 5 Replies | 3330 Views | Created by arsenearsenal - Thursday, May 9, 2013 3:06 PM | Last reply by Naomi N - Thursday, May 9, 2013 4:16 PM -
0 Votes
Report Builder 3.0 Parameter issue. Must declare scalar value
. However after I enter a value it gives an error of "must declare the scalar variable @state1" sqlsrv32.dll I could change ...Discussion | 2 Replies | 871 Views | Created by cronkfield - Monday, May 19, 2014 2:31 PM | Last reply by cronkfield - Monday, May 19, 2014 3:37 PM -
0 Votes
must declare the scalar value @date
Please I am having the must declare the scalar value when using a dynamic sql, the threads have read are mostly dealing with when the variable is int, but ...Answered | 4 Replies | 1443 Views | Created by I4QR1A - Monday, December 14, 2015 11:38 AM | Last reply by I4QR1A - Monday, December 14, 2015 2:16 PM -
0 Votes
SP2010 SQL Exception 137 Must declare the scalar variable "@wssp4".
;System.Data.SqlClient.SqlException: Must declare the scalar variable "@wssp4". at ...Answered | 4 Replies | 10965 Views | Created by klinkby - Wednesday, March 9, 2011 10:45 AM | Last reply by turbodude - Wednesday, March 19, 2014 1:14 PM -
0 Votes
Must declare scalar value
I am trying to pass parameter(@EmpID)into my function to calculate some data(TaxableAmount and NetPay). However I am getting "Must declare scalar value". ...Answered | 14 Replies | 747 Views | Created by _birdy - Sunday, August 13, 2017 6:18 AM | Last reply by BonnieB - Thursday, August 17, 2017 3:21 PM -
0 Votes
must declare a scalar variable
(@sql) this doesnt work. it says must declare a scalar variable. i even tried doing it like this : set @sql = 'select * ...Answered | 2 Replies | 6197 Views | Created by MeeraP - Tuesday, April 21, 2009 10:05 AM | Last reply by PeterParkerNeo - MCTS, MCITP - Tuesday, April 21, 2009 10:11 AM -
0 Votes
TFSbackup failed Must declare the scalar variable "@BackupCompressionDefault"
Here is the event log System.Data.SqlClient.SqlException (0x80131904): Cannot assign a default value to a local variable. Must declare ...Answered | 5 Replies | 2800 Views | Created by eric42 - Monday, April 29, 2013 9:12 AM | Last reply by Christian HL - MSFT - Saturday, May 4, 2013 12:33 AM -
0 Votes
Must declare Scalar variable
Hi, I am using Vb.net with Sql and have the following error. Must declare Scalar variable "@ScoreDate"Answered | 3 Replies | 4126 Views | Created by Cmrnp - Wednesday, January 24, 2007 10:06 AM | Last reply by William Ryan - Wednesday, January 24, 2007 2:43 PM -
0 Votes
Error Must declare the scalar variable?
parentheses around the variable, the report fails to render and the “must declare the scalar variable” error is displayed. You use a parameter ...Answered | 5 Replies | 808 Views | Created by Dave Oh - Monday, January 4, 2016 7:15 PM | Last reply by Dave Oh - Tuesday, January 5, 2016 5:08 PM -
0 Votes
Passing A Database Name Parameter
dropdown list the database name. I have created a query to create the dropdown list of database names for the @ServerDB parameter. I get an error stating must ...Answered | 1 Replies | 4279 Views | Created by RudyCat - Monday, October 24, 2011 6:14 PM | Last reply by John Bocachica - Monday, October 24, 2011 8:06 PM -
0 Votes
SQLCommand Problem: Must declare the scalar variable
I have a SQLCommand which contains a simple INSERT query but when I try to execute it I get an error message "Must declare the scalar variable ...Answered | 3 Replies | 9692 Views | Created by Jinwah - Wednesday, October 31, 2007 10:47 AM | Last reply by Bob Palmer - Wednesday, October 31, 2007 11:03 AM -
1 Votes
Must declare scalar vaiable
do work criteria not met do work Msg 137, Level 15, State 1, Line 2 Must declare the scalar ...Answered | 8 Replies | 919 Views | Created by Chickoo79 - Wednesday, June 22, 2016 3:33 PM | Last reply by Chickoo79 - Wednesday, June 22, 2016 6:01 PM -
0 Votes
Must Declare a Scalar Variable
/////////////////////////////////////////////////////////////////////////////////////// Sorry I forgot to put the error : ...Answered | 2 Replies | 1794 Views | Created by Farshad Zamani2013 - Wednesday, May 8, 2013 9:16 AM | Last reply by Farshad Zamani2013 - Wednesday, May 8, 2013 10:07 AM -
0 Votes
"Must declare scalar variable"
Can someone please put the following code into the format asked.I keep getting errors like "Must declare scalar variable"Answered | 3 Replies | 8227 Views | Created by solidrambo - Monday, April 11, 2011 2:22 PM | Last reply by Manoj Pandey (manub22) - Wednesday, April 13, 2011 6:51 AM -
1 Votes
must declare scalar variable
Heey Guys Got this strange error when try to save a Sql view (must declare scalar variable ...Answered | 13 Replies | 4679 Views | Created by Nikola12 - Thursday, November 8, 2012 10:22 AM | Last reply by Olaf Helper - Thursday, November 8, 2012 1:02 PM -
0 Votes
must declare the scalar variable
name of a parameter that has been defined before using to set the value. So, in this case, when you declare the parameters manually, the program works fine.Answered | 2 Replies | 6613 Views | Created by Moshe Y - Wednesday, March 25, 2009 10:29 PM | Last reply by Moshe Y - Sunday, April 5, 2009 9:05 AM -
0 Votes
Stored Proc with SSRS multi value parameter gives " Must Declare scalar Varaiable @StateID
Visakh, I changed @StateID date type to varchar(max) and still I get this error. System.Data.SqlClient.SqlException: Must declare the ...Answered | 4 Replies | 1572 Views | Created by sql9 - Wednesday, October 1, 2014 3:16 AM | Last reply by sql9 - Wednesday, October 1, 2014 2:09 PM - Items 1 to 20 of 2837032 Next ›
No announcements
