Damsure-601330
SSC Enthusiast
Points: 142
More actions
May 8, 2008 at 7:52 am
#190399
I converted a ACCESS DB to sql2005 no problem, But the created Queries in ACCESS got converted as tables is there any way to take a created Query from ACCES and convert it to SQL2005 VIEW?? or are we talking re-write?? lol
antonio.collins
SSCrazy Eights
Points: 9600
May 8, 2008 at 10:27 am
#812542
access supports vb functions like iif() in queries. so, you'll have to rewrite them as transact-sql.
May 8, 2008 at 10:53 am
#812555
Figured that thanks!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply