Tag: zonixsoft

MERGE Command in SQL Server

visit: https://zonixsoft.com (our official website) In SQL Server 2008, Microsoft introduces the MERGE functionality through the MERGE command. The MERGE command inserts rows that don’t exist and updates the rows that do exist.     What MERGE Command works as,         IF FOUND            THEN UPDATE         ELSE            INSERT;     Until now, this MERGE functionality could […]

CASE (Transact SQL)

Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two formats: · The simple CASE function compares an expression to a set of simple expressions to determine the result. · The searched CASE function evaluates a set of Boolean expressions to determine the result. Examples: A. Using a SELECT […]

CASE (Transact SQL)

Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two formats: · The simple CASE function compares an expression to a set of simple expressions to determine the result. · The searched CASE function evaluates a set of Boolean expressions to determine the result. Examples: A. Using a SELECT […]

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 […]

New in C-Sharp 3.0

Visit: https://zonixsoft.com New in C-Sharp 3.0 New in C# 3.0 This article discusses the following major new enhancements expected in C# 3.0: • Implicitly typed local variables • Anonymous types • Extension methods • Object and collection initializers • Lambda expressions • Query expressions • Expression Trees Implicitly typed local variables: C# 3.0 introduces a new keyword called “var”. Var allows you […]

Code Sample to Upload file to FTP Server

Visit: https://zonixsoft.com check out below code to upload file to FTP Server:   /// <summary> /// Code to upload file to FTP Server /// </summary> /// <param name=”strFilePath”>Complete physical path of the file to be uploaded</param> /// <param name=”strFTPPath”>FTP Path</param> /// <param name=”strUserName”>FTP User account name</param> /// <param name=”strPassword”>FTP User password</param> /// <returns>Boolean value based […]