Browse by Tags

All Tags » ADO.NET (RSS)

How to do virtual paging with ASP.NET, AJAX and SQL Server 2005 by marianor

This sample provides a way to avoid full postback of the page, just updating the grid that contains the data. The first step is create the stored procedure, for that I will use CTE (Common Table Expressions), which is a new feature of SQL Server 2005...
Filed under: , ,

Parsing SQL Like to avoid overloads SQL Server by marianor

When using Stored Procedures or embeds SQL in a query generally we forget about parse the parameters where a Like condition is present. The are two possible wildcards for the LIKE function in SQL Server, that are _ (underscored), that replaces a character...
Filed under:
More Posts