No announcements
Found 642737 threads
-
1 VotesMust declare the scalar variable.
Because SQL is a declarative language, we do not use local variables.Answered | 7 Replies | 27187 Views | Created by KamAbA - Thursday, October 3, 2013 11:51 AM | Last reply by Josh Ashwood - Tuesday, October 8, 2013 5:41 AM
-
0 Votes
How to declare a table variable in SSIS and then insert rows into it
SQL Insert, Update, Delete, and Select statements return a large amount of informational data on the execution of the statements.Answered | 12 Replies | 31038 Views | Created by CostinP - Thursday, September 9, 2010 11:44 AM | Last reply by Joifer Santos - Friday, March 15, 2013 1:18 PM -
0 Votes
How to Declare a variable in Execute SQL task to Insert a row..?
" failed with the following error: "Must declare the scalar variable "@column".Answered | 3 Replies | 20251 Views | Created by Roger Binny - Tuesday, July 7, 2009 8:43 PM | Last reply by Thisme - Wednesday, August 1, 2012 3:17 AM -
0 Votes
Declare multiple values in a variable
What do you want to do with if having multiple values in a variableAnswered | 6 Replies | 7177 Views | Created by SQL_Gun - Thursday, October 10, 2013 11:39 PM | Last reply by Dinesh Kumar Rajendran - Friday, October 11, 2013 5:26 AM -
0 Votes
Variables Declaration
my question... in the windows forms c++, HOW DO I DECLARE VARIABLES in vb its: dim Mystring as String dim ...Answered | 11 Replies | 701 Views | Created by RickSmit123 - Wednesday, August 10, 2016 5:36 AM | Last reply by RickVBplayer - Friday, August 12, 2016 4:19 AM -
0 Votes
Declaring variables with values
I think ANSI standards apply to the select/update/insert/delete statements, not to declaration statements.Answered | 1 Replies | 4822 Views | Created by NashVegas - Wednesday, September 8, 2010 9:19 PM | Last reply by Naomi N - Wednesday, September 8, 2010 9:23 PM -
3 Votes
[VB.NET] Declared variable appearing not declared?!
I think instead of MOVING the declaration from the If to the Sub scope you COPIED the declaration so it still exists in both places.Answered | 3 Replies | 3612 Views | Created by Xakepa - Thursday, February 24, 2011 6:13 PM | Last reply by Andrew B. Painter - Thursday, February 24, 2011 7:10 PM -
3 Votes
Variable not declared?
If it is saying that when you have moved the code into a method then it is becausue there is no variable named "TextBox1" declared in your ...Answered | 7 Replies | 1418 Views | Created by Ginsberg - Sunday, November 25, 2012 9:10 PM | Last reply by Kareninstructor - Monday, November 26, 2012 3:05 AM -
0 Votes
Must declare the scalar variable problem
Dude, you didn't declare this variable. :) you declared '@dateCreated' and are calling as '@dataCreated'...Answered | 4 Replies | 5158 Views | Created by JonKho - Saturday, February 6, 2010 3:12 PM | Last reply by JonKho - Saturday, February 6, 2010 4:03 PM -
0 Votes
Declare a variable with stored procedure
In SQL 2000 you can not use INSERT EXECUTE with table variables.Answered | 17 Replies | 6913 Views | Created by TinyJimbo - Friday, August 6, 2010 6:59 PM | Last reply by TinyJimbo - Friday, August 6, 2010 8:49 PM -
0 Votes
Declare a variable inside a Expression
You cannot declare variables inside an expression shape.Answered | 4 Replies | 11303 Views | Created by lilSam21 - Wednesday, October 21, 2009 4:16 PM | Last reply by Manh Hung Chu - Sunday, June 6, 2010 8:30 PM -
7 Votes
Declaring Memory Variables
In regard to form properties, you can declare or define them at runtimes as you can declare variables at runtime via Addproperty() function or method and ...Answered | 37 Replies | 6920 Views | Created by MsJae - Thursday, June 2, 2011 2:37 PM | Last reply by Olaf Doschke - Wednesday, June 8, 2011 10:12 AM -
0 Votes
Declare and Use Variable
No, the variables are only visible in one batch.Answered | 8 Replies | 7891 Views | Created by MDMoura - Wednesday, October 6, 2010 1:48 PM | Last reply by MDMoura - Thursday, October 14, 2010 3:04 PM -
1 Votes
INSERT INTO Table variable not in Table variable
" on my 4th insert statement.Answered | 8 Replies | 29321 Views | Created by Rikz - Tuesday, January 29, 2013 11:30 PM | Last reply by Martin Smith - Thursday, January 31, 2013 10:54 AM -
0 Votes
using declared variable
The error message is self explanatory A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.Answered | 4 Replies | 997 Views | Created by Rainbow55 - Monday, December 9, 2013 1:43 PM | Last reply by Rainbow55 - Monday, December 9, 2013 1:55 PM -
2 Votes
Things About Variable Declaration
You should only use DIM and STATIC to declare variables within a SUB or FUNCTION.Answered | 37 Replies | 3739 Views | Created by Sam9584 - Wednesday, January 19, 2011 7:33 AM | Last reply by Sam9584 - Thursday, January 20, 2011 4:05 PM -
0 Votes
declaring a variable with brackets
Hi, I was hoping that I could declare variables in t-sql with brackets.Answered | 1 Replies | 4795 Views | Created by db042188 - Friday, November 6, 2009 4:13 PM | Last reply by Kalman Toth - Friday, November 6, 2009 4:22 PM -
1 Votes
Variable not declared....
It tells you that you have some of those gm_... variables declared twice, and that the declaration in Top_Module is not accessible for ...Answered | 40 Replies | 1256 Views | Created by FenixRising - Saturday, March 21, 2015 7:52 AM | Last reply by Kareninstructor - Tuesday, March 24, 2015 6:15 PM -
0 Votes
"Must declare scalar variable"
3:14 PM -- Description: <Description> -- ================================ CREATE PROCEDURE dbo.usp_InsertOrder -- Add the parameters for the procedure ...Answered | 3 Replies | 8618 Views | Created by solidrambo - Monday, April 11, 2011 2:22 PM | Last reply by Manoj Pandey (manub22) - Wednesday, April 13, 2011 6:51 AM -
5 Votes
declare a variable calss with dim
One integer variable can have a different value from another integer variable and so on....Answered | 17 Replies | 3536 Views | Created by Baby_Tehran - Friday, March 18, 2011 1:10 PM | Last reply by SJWhiteley - Monday, March 21, 2011 12:03 PM - Items 1 to 20 of 642737 Next ›
No announcements
