title: In ColdFusion how to Convert LIMIT function query in MY SQL to MS SQL Server 2012
body: <p>Please see below example:</p>
  
  <pre><code>&lt;cfquery name="getAllMembers" datasource="#application.dsn#"&gt;
      SELECT  DCNumber,RegDate,gender,FirstName,LastName,(select count(*) from DriversRecord) as totalCount
              FROM DriversRecord
  
      LIMIT &lt;cfqueryparam value="#start#" cfsqltype="cf_sql_integer" /&gt;,&lt;cfqueryparam value="#paginationArgs.rowsPerPage#" cfsqltype="cf_sql_integer" /&gt;
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>How can I covert  this query  which is in MY SQL But I am using MS SQL 2012 MS SQL?</p>