Category: SQL Server

Paging in SQL Server

Visit: https://zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView cause the Performance issue when we have thousands and thousands of records in our database; because with every roundtrip to the data-server, […]

Paging in SQL Server

Visit: https://zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Server) As a Web developer, you know by now that using the default paging capabilities of ASP.NET Webcontrols like DataGrid and GridView cause the Performance issue when we have thousands and thousands of records in our database; because with every roundtrip to the data-server, […]

Using TRY-CATCH to Rollback a Transaction in the Face of an Error

Visit : https://zonixsoft.com (our official website) Error Handing in Sql Server 2005. The release of Sql Server 2005 has provided us somany features over its predecessor. No doubt that more preference is given to the tasks performed by the administrator. But there are some new development features added to make your Sql Code more powerful […]

Passing lists to SQL server stored procedures

Visit : https://zonixsoft.com (our official wbsite) Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: · INSERT […]

Passing lists to SQL server stored procedures

Visit : https://zonixsoft.com (our official wbsite) Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: · INSERT […]

Passing lists to SQL server stored procedures

Click Here to visit Zonix’s Website Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: INSERT a […]

Passing lists to SQL server stored procedures

Click Here to visit Zonix’s Website Article is about: The ability to pass “a list of values” from .Net as a parameter to a T-SQL based stored procedure. Scenarios: There are lots of scenarios where we need to pass a list of values to save in database. Here’s a couple of obvious ones: INSERT a […]