Home Forums SQL Server 7,2000 T-SQL How to give Parameter value to the function RE: How to give Parameter value to the function

  • GilaMonster - Monday, August 14, 2017 1:43 AM

    Newbi - Sunday, August 13, 2017 8:47 PM

    By the way, mind explaining me why you Select TOP 20 when using cross apply, rather than just select?

    Paging. So that the app gets back only 20 rows, not possibly thousands. If you have client-side paging, or if there's not much data, you won't need that.

    Correct.  I only meant it as a placeholder for whatever mechanism you're using for paging.