public List queryCargos(int first,int max){
Query query=getHibernateTemplate().getSessionFactory().
getCurrentSession().createQuery("from Cargo");
query.setFirstResult(0);
query.setMaxResults(10);
return query.list();
}

I use MSSQL AS DATABASE,when my application run, it comes with a errro message "there is error around 'limit'" .
I know can not use "select * from cargo limit 0,10" usage in mssql,but in mysql ,it can run.
How to get the limited record in mssql ?

Try reading http://forum.hibernate.org/viewtopic.php?t=961035&highlight=limit