In this post, I am showing a SSMS option to set the ROWCOUNT for getting the fixed number of records by all SQL Query for SQL Server. If you are aware of MySQL Workbench, it also returns only top 1000 default rows for all query results. SQL Server SSMS also has this kind option to […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.