Converting MySQL LIMIT to SQL Server "Denali"

Posted by wellyslee (SSMA Team's Blog) on July 13, 2011

One of the new feature in SSMA for MySQL v.5.1 is the support for converting MySQL LIMIT clause to SQL Server “Denali” OFFSET/FETCH NEXT clause.


LIMIT is commonly used in MySQL statement to support query paging functionality. SQL Server “Denali” includes OFFSET/FETCH NEXT clause which can be

... [read more]

Rating

not rated
Login to rate this.

Reviews

Submit a comment / review

There are currently no comments or reviews.

Related

  • In one of my current projects I have some pivot reports that show count of issues in different states. Grouping depends on report. States are dynamic ...
    By Gunnar Peipman on January 2, 2012
  • How to set SharePoint blog comments permission If you want to allow your SharePoint blog visitors to comment on blog posts you need to explicitly...
    By zakir hossain on March 31, 2011
  • Hi All, Ari Ijäs shared a nice post includes a simple steps to configure Search Services Application in SharePoint Server 2010 to crawling for anony...
    By Mohamed Abdel Ghaffar on April 16, 2011
  • A while back, I showed how you could use the query syntax and Rx to code a drag-drop operation similar to the way you might describe  the process to ...
    By Thinq LINQ on August 27, 2011
  • This was something that seemed impossible for Sharepoint to do, but with a little trickery with XPath under the bonnet of Sharepoint Designer, prove...
    By EndUserSharePoint.com on April 15, 2010
  • Reason : Some time data pumb jobs marked as orphaned (stopped abnormally) and job information still remain in database. On starting datapump job star...
    By Blogger on August 17, 2010
  • though logically the same, this is easier to read: select coalesce( (select CURRENT_TIMESTAMP > unlocked_expiration from i...
    By Michael Buen on April 24, 2008
  • Formula:Memory Consumed = (Number of Oracle Processes + 1) X (Size of Patched)Example:memory consumed = [ (select value from v$parameter where name='p...
    By javeedkaleem on January 13, 2012

Submit a review:

Login required.