Please see below example:
<cfquery name="getAllMembers" datasource="#application.dsn#">
SELECT DCNumber,RegDate,gender,FirstName,LastName,(select count(*) from DriversRecord) as totalCount
FROM DriversRecord
LIMIT <cfqueryparam value="#start#" cfsqltype="cf_sql_integer" />,<cfqueryparam value="#paginationArgs.rowsPerPage#" cfsqltype="cf_sql_integer" />
</cfquery>
How can I covert this query which is in MY SQL But I am using MS SQL 2012 MS SQL?