Thanks Martijn!
That I understood, sorry I wasn't clear enough, I was more confused about
the "TOP 100 PERCENT" and this was a bad example anyways, but after posting
I did some deeper research and found an excellent migration white paper
describing this type of expressions and mysql counterparts. Tomorrow I'll
post the url as I don't have it right now on my laptop, I saved the link on
my desktop. Anyways I thank you for your comments.
:handshake:
Martijn Tonies wrote:
>
> Hey,
>
>> In order for me to achive the goal of migrating a MS SQL based
>> application
>> to web based php / mysql I need to understand a little bit MS SQL syntax
> and
>> MySQL counterpart expression. If is not too much to ask one of you guys
>> could "translate" this MS SQL select to MySQL? Here's the challenge:
>
> Yes, that is too much. This is a very basic query, if you cannot translate
> it yourself, I wish you good luck on your conversion project.
>
> Is there anything -specific- that you want to have translated here?
>
> Would it help if I said that this query prefixes each object with its
> owner
> (dbo)
> and for MySQL you should remove that?
>
> eg:
>
> create view equipos ...
>
> select ... OBJETOSPATRIMONIO.objpatCodigo
> ...
> from `01 LOCALIZACIONES OBJETOSPATRIM` INNER JOIN
> ...
>
> Martijn Tonies
> Database Workbench - development tool for MySQL, and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>> CREATE VIEW dbo.equipos
>> AS
>> SELECT TOP 100 PERCENT dbo.OBJETOSPATRIMONIO.objpatCodigo AS Expr1,
>> dbo.OBJETOSPATRIMONIO.objpatDenom AS Expr2,
>> dbo.OBJETOSPATRIMONIO.objpatEstadoTec AS Expr3,
>> dbo.ESTRUCTURAPATRIMONIO.clsnodopatID,
>> dbo.[01 LOCALIZACIONES OBJETOSPATRIM].Localizacion
>> FROM dbo.[01 LOCALIZACIONES OBJETOSPATRIM] INNER JOIN
>> dbo.OBJETOSPATRIMONIO ON dbo.[01 LOCALIZACIONES
>> OBJETOSPATRIM].objpatID = dbo.OBJETOSPATRIMONIO.objpatID INNER JOIN
>> dbo.OBJETOSPATRIMEQUIPOS ON
>> dbo.OBJETOSPATRIMONIO.objpatID = dbo.OBJETOSPATRIMEQUIPOS.equipID INNER
> JOIN
>> dbo.ESTRUCTURAPATRIMONIO ON
>> dbo.OBJETOSPATRIMONIO.objpatNodoEnlazID =
>> dbo.ESTRUCTURAPATRIMONIO.nodopatrimID
>> ORDER BY dbo.OBJETOSPATRIMONIO.objpatCodigo
>>
>>
>> Really appreciate your help! Thanks!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
>
--
View this message in context:
http://www.nabble.com/MS-SQL-to-MySQL-select-tp17846568p17859366.html
Sent from the MySQL - General mailing list archive at Nabble.com.
