No announcements
Found 3622226 threads
-
0 VotesUsing a Variable In a SQL Query
Since you have declared the variable with int data type, you should know that the value "5" or "6" is a string data (char or varchar).Answered | 4 Replies | 1034 Views | Created by Rich Ellis-MC - Friday, August 31, 2018 9:59 PM | Last reply by Xi Jin - Monday, September 3, 2018 3:27 AM
-
0 Votes
Query rule using query variables
Make sure you have set the value of query variable {user.preferredcontentlanguage}, it will return -1 if not set.Answered | 1 Replies | 1207 Views | Created by MNaresh - Tuesday, February 17, 2015 7:01 PM | Last reply by Sara Fan - Thursday, February 19, 2015 3:45 AM -
2 Votes
Using Variables in an SQL Script
Looks like you're missing the schema name and you'll want to use QUOTENAME to add delimiters to the objects e.g.Answered | 4 Replies | 711 Views | Created by ArnolddG - Thursday, March 12, 2015 5:06 PM | Last reply by ArnolddG - Thursday, March 12, 2015 5:37 PM -
0 Votes
Variable Schema name in SQL Query
After research , I got conclusionthat when you use table name or field name as variable, you have to change the SQL as the dynamic SQL .Answered | 4 Replies | 1435 Views | Created by AlexMaier74 - Monday, June 18, 2018 10:45 AM | Last reply by Mitarai Queen - Tuesday, June 19, 2018 3:06 AM -
0 Votes
Passing Variable in SQL Query
with openquery you will need to use dynamic sql in order to put the variables in there.Answered | 4 Replies | 3908 Views | Created by obrienkev - Tuesday, March 9, 2010 1:18 PM | Last reply by onpnt - Tuesday, March 9, 2010 7:47 PM -
1 Votes
Temporary variables in SQL 2000 queries
Query execution time greater when using a variable in the where clause, why?Answered | 4 Replies | 4467 Views | Created by Marek Dzikiewicz - Thursday, January 15, 2009 2:00 PM | Last reply by Hunchback - Saturday, January 17, 2009 5:07 PM -
0 Votes
Access query vs SQL query
Are the cardinalities the same in the contactExtract table for both SQL Server and Access?Answered | 6 Replies | 3713 Views | Created by Swan_E - Wednesday, July 1, 2009 11:28 AM | Last reply by John Ang_ - Wednesday, July 1, 2009 1:46 PM -
1 Votes
Variables in TableAdapter queries...
In a DataSet's TableAdapter , for a Access database connexion , you use the below query if you need a filter parameter .Answered | 7 Replies | 20097 Views | Created by mracuraintegra - Friday, April 14, 2006 2:11 AM | Last reply by Eid Almuabark - Tuesday, August 30, 2011 7:34 AM -
2 Votes
How to set result of SQL query into a variable using Execute sqltask in ssis?
Follow these steps: 1.In executable SQL task select a appropriate query that returns a result.Answered | 1 Replies | 2006 Views | Created by Shivam.Bajpayee - Tuesday, August 28, 2012 6:52 AM | Last reply by Arihant.Jain - Tuesday, August 28, 2012 6:59 AM -
4 Votes
SQL Server variable declarations and the query optimizer
I know you can see memory grants...etc. in query plans and such, but I just wasn't sure what it did for variables.Answered | 10 Replies | 3383 Views | Created by John Couch - Sunday, October 7, 2012 6:56 AM | Last reply by John Couch - Monday, October 8, 2012 7:38 PM -
1 Votes
Query Results to variable not working
I'm trying to create a variable on a form.Answered | 3 Replies | 1180 Views | Created by abbey normal - Thursday, December 6, 2012 11:41 PM | Last reply by abbey normal - Friday, December 7, 2012 3:33 PM -
0 Votes
Executing query as variable, no parameters?
OK thanks, I tried that vairable in the execute SQL task when i try to run the query in the query editor: And when I ...Answered | 4 Replies | 3485 Views | Created by DDT12 - Monday, September 10, 2012 9:15 PM | Last reply by DDT12 - Monday, September 17, 2012 6:45 PM -
1 Votes
SQL query returns value but EXEC SQL Task fails to assign variable
I'm not using any literals in the query.Answered | 16 Replies | 4169 Views | Created by Thursty - Wednesday, January 22, 2014 6:32 PM | Last reply by davidbaxterbrowne - Wednesday, January 22, 2014 10:27 PM -
0 Votes
Importing data from access to sql using a query
The NZ function does not parse as a valid query in the import wizard from access to sql, but the idea you gave me for the iif function worked.Answered | 5 Replies | 545 Views | Created by Debra has a question - Thursday, April 14, 2016 5:09 PM | Last reply by Debra has a question - Monday, May 2, 2016 3:39 PM -
0 Votes
Use Variable
I dont want to query tbl again and hence want to use the variable user::bodyAnswered | 19 Replies | 3391 Views | Created by Desigal59 - Wednesday, August 26, 2009 7:48 PM | Last reply by Nitesh Rai - Friday, August 28, 2009 5:47 AM -
0 Votes
Conversion of access queries to SQL
Arbi, Thank you for the query.Answered | 4 Replies | 6206 Views | Created by gouthamraj - Thursday, July 7, 2011 8:09 PM | Last reply by gouthamraj - Monday, July 11, 2011 3:11 PM -
0 Votes
SQL Query Files with VBS variables
Environemnt Variables (System/User) or they might have used 2.Answered | 5 Replies | 2784 Views | Created by anon1m0us - Friday, January 4, 2013 3:52 PM | Last reply by anon1m0us - Wednesday, January 9, 2013 7:11 PM -
1 Votes
Use Table Variable In Dynamic SQL
You could just do the following to move the variable table to the scope of the dynamic query: SET @sql = 'DECLARE @indigo AS ...Answered | 2 Replies | 11480 Views | Created by IndigoMontoya - Tuesday, March 29, 2016 5:54 PM | Last reply by Thabiso Michael Mofokeng - Tuesday, January 29, 2019 2:00 PM -
4 Votes
Stored Procedure using output variable to run a query made with dynamic SQL
We are used result of this two variable in other query.Answered | 10 Replies | 6247 Views | Created by sqlservernoob - Tuesday, December 4, 2012 8:14 PM | Last reply by SANJAY KHACHANE - Wednesday, December 26, 2012 12:13 PM -
0 Votes
using a form to decide a query variable
in your query criteria use the form's combo box as the criteria information i.e.Answered | 6 Replies | 1168 Views | Created by R_West - Tuesday, August 21, 2012 9:35 PM | Last reply by -suzyQ - Wednesday, August 22, 2012 4:18 AM - Items 1 to 20 of 3622226 Next ›
No announcements
