Community

More From the You-Can’t-Know-Everything-Dept: A TSQL tidbit

(Julia Lerman) I was recently creating a stored procedure in SQL Server for a client to do reporting on. THey wanted the ability to decide at report time how many records should be returned. I knew the “hack” in SQL Server 7 and 2000 (using ROWCOUNT) but discovered that with SQL Server 2005, you can

Read More - Register for Free Membership