No announcements
Found 642698 threads
-
2 VotesThings About Variable Declaration
You should only use DIM and STATIC to declare variables within a SUB or FUNCTION.Answered | 37 Replies | 3786 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 | 4852 Views | Created by db042188 - Friday, November 6, 2009 4:13 PM | Last reply by Kalman Toth - Friday, November 6, 2009 4:22 PM -
0 Votes
Declaring and Setting Variables
If you are talking about predefining all variables automatically based on SELECT * FROM Table, there is no way to do so with variables, all variables would need to be ...Answered | 2 Replies | 763 Views | Created by Brandon De Flon - Thursday, July 23, 2015 3:29 PM | Last reply by SQLGru - Thursday, July 23, 2015 3:59 PM -
0 Votes
Declaring Scalar variable
The actual SqlCommand will be as follows: SqlCommand command=new SqlCommand("INSERT INTO STUDINFO_TBL(MATRICNO,FIRST_NAME, LAST_NAME, DEPT,LEVEL,CGPA,MODEOFENTRY) ...Answered | 2 Replies | 1264 Views | Created by jerofad - Thursday, November 7, 2013 9:11 AM | Last reply by jerofad - Thursday, November 7, 2013 10:10 AM -
1 Votes
insert values from variable into table variable
Hi Kumar KV, I guess you need Table Valued Splitter function which provides splitted values from delimited string variable.Answered | 6 Replies | 1488 Views | Created by kumarkv - Wednesday, November 4, 2015 4:26 AM | Last reply by Jingyang Li - Wednesday, November 4, 2015 3:37 PM -
0 Votes
Issue with declaring SQL In local variables
Thanks Erland, I was going to bring either @loggedVarTrue or @loggedVarFalse into the query depending on another variable that I will carry into ...Answered | 7 Replies | 6044 Views | Created by Boomfelled - Friday, April 1, 2011 10:01 AM | Last reply by Erland Sommarskog - Friday, April 1, 2011 9:43 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 | 8677 Views | Created by solidrambo - Monday, April 11, 2011 2:22 PM | Last reply by Manoj Pandey (manub22) - Wednesday, April 13, 2011 6:51 AM -
0 Votes
Dynamic SQL and Table Variables (Declaration Issues)
to Scott_Morris-ga: I am using the rowcount to populate a variable in an SSIS package.Answered | 9 Replies | 4862 Views | Created by Rookie3000 - Wednesday, September 11, 2013 11:10 PM | Last reply by Rookie3000 - Thursday, September 12, 2013 7:01 PM -
0 Votes
Dynamically declaring variable
If there is any specific reason that you want to declare variables only??Answered | 4 Replies | 6209 Views | Created by Thomas Stanton - Wednesday, March 9, 2011 12:16 AM | Last reply by Derek Smyth - Wednesday, March 9, 2011 8:41 AM -
0 Votes
Must declare the table variable "@CustomData".
Hi Montadar, The Problem is that you are refering the table variable inside the Dynamic sql and the dynamic sql has a completely different scope so the table ...Answered | 2 Replies | 2651 Views | Created by Montadar - Tuesday, September 15, 2015 3:22 PM | Last reply by Montadar - Monday, November 2, 2015 10:32 PM -
1 Votes
must declare scalar variable
See my previous post, you can't use variable in a VIEW.Answered | 13 Replies | 5534 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
Use Implicitly Typed Variable Declaration
dynamic variables are not strongly typed.Answered | 11 Replies | 6276 Views | Created by JeffWask - Wednesday, May 19, 2010 4:52 PM | Last reply by RhinoMonkey.com - Wednesday, August 22, 2012 6:40 PM -
1 Votes
Must declare the scalar variable?
statement must be either a Unicode constant or a Unicode variable.Answered | 5 Replies | 8208 Views | Created by Westside2008 - Tuesday, March 6, 2012 2:56 AM | Last reply by Naomi N - Tuesday, March 6, 2012 3:36 AM -
0 Votes
Declare variables-Tsql
Variable names can begin with a letter or an underscore, this is a standard.Answered | 7 Replies | 1956 Views | Created by Maverick008 - Thursday, December 6, 2012 10:48 PM | Last reply by Johnny Bell Jnr - Friday, December 7, 2012 9:55 AM -
0 Votes
Declaring A Variable
Better to use SELECT than SET DECLARE @ID int; SELECT @ID = 1;Answered | 2 Replies | 6235 Views | Created by sirMilt - Wednesday, November 3, 2010 12:49 PM | Last reply by Ali Hamdar - Wednesday, November 3, 2010 1:11 PM -
0 Votes
Must declare the scalar variable
This is done as: exec dbo.spGetPager @Imageid = 3, @TotalRows = @undeclaredlocal var output; Notice that I assumed the existence of a local ...Answered | 3 Replies | 18113 Views | Created by SowSanura - Tuesday, March 25, 2014 4:46 AM | Last reply by scott_morris-ga - Tuesday, March 25, 2014 1:23 PM -
1 Votes
Declare field as a variable in SQL
Declare @price_type as varchar(50) set @price_type = 'nHighPrice' SELECT top 2 g.tPriceDescID as price_desc_id , e.tName as price_type_name ...Answered | 6 Replies | 1043 Views | Created by SyedF - Wednesday, March 4, 2015 1:16 PM | Last reply by Jingyang Li - Thursday, March 5, 2015 2:17 PM -
0 Votes
Bulk INsert with variable Lastrow
Msg 137, Level 15, State 2, Line 1 Must declare the scalar variable "@COUNT".Answered | 24 Replies | 5633 Views | Created by ryguy72 - Monday, March 31, 2014 9:17 PM | Last reply by Erland Sommarskog - Tuesday, April 1, 2014 7:38 PM -
0 Votes
Declaring multiple variables in a single statement?
This is a code snippet: private Dictionary<string, int> ints = new Dictionary<string, int>(); private void Initialize() { for ...Answered | 2 Replies | 2885 Views | Created by Jackson Riley - Thursday, December 31, 2009 8:42 AM | Last reply by Aland Li - Tuesday, January 5, 2010 9:04 AM -
0 Votes
Declaring temp table produces Msg 1087 "Must declare the table variable"
DECLARE @MaxThinning TABLE ( CID int NOT NULL, LegConditionId int NOT NULL, ...Answered | 1 Replies | 1809 Views | Created by Chris Allen - Data Architect - Tuesday, February 23, 2016 3:27 PM | Last reply by Olaf Helper - Tuesday, February 23, 2016 3:32 PM
No announcements
