Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors?

Answer Posted / guest

You can use a variable as your IN clause, but this requires
that you use the EXEC function to run the statement.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger in salesforce?

1049


What is query cost in sql server?

1035


What is the importance of concurrency control?

1271


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

1002


Explain differentiate between a having clause and a where clause?

949


How are the exceptions handled in sql server programming?

1113


What happens if an integer is too big for int date type?

1023


When cursors are useful?

1166


How to find related tables in sql server?

997


You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1123


Why is normalisation important?

986


What purpose does the model database server?

1143


What is the purpose of a table?

993


Can a function call a stored procedure in sql server?

1000


How to find index size for each index on table?

1050