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

How do I debug a stored procedure in sql server?

1092


What is factless fact table? : sql server analysis services, ssas

1017


Mention what are the core components of ssrs?

323


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1006


Explain optimistic and pessimistic concurrency?

985


How to see existing views in ms sql server?

1032


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1598


Do you know what is xpath?

1076


What are relationships and mention different types of relationships in the dbms

957


How to call stored procedure using http soap?

1064


What happens when the SQL Azure database reaches Max Size?

111


Can two tables share the same primary key?

905


What is the rdl file?

138


Can We Use Data-grids For Our Report In Ssrs?

184


Can sql servers linked to other servers like oracle?

938