Blogs about: Zonix Software Solutions
Featured Blog
Multiple Active Result Sets (MARS - ADO.NET 2.0)
Multiple Active Result Sets (MARS) is a feature in ADO.NET 2.0. It allows execution of multiple batches against Database on a single connection. Preeviously, only one batch could be executed at a time… more →
Zonix Software Solutions
Multiple Active Result Sets (MARS - ADO.NET 2.0)
Kaushal wrote 1 year ago: Multiple Active Result Sets (MARS) is a feature in ADO.NET 2.0. It allows execution of multiple batc … more →
How Big is google's database
— 1 comment
zonixsoft wrote 1 year ago: Visist : http://www.zonixsoft.com (Our Official Website) Google search crawler uses 850 TB of inform … more →
The real difference between SQL Server and Oracle
zonixsoft wrote 1 year ago: Visit : http://www.zonixsoft.com (our Official website) For years now there’s been a constant … more →
UPDATE Based Off of A Table
— 1 comment
zonixsoft wrote 1 year ago: visit : http://www.zonixsoft.com (our official website) INSERT offers the ability to insert into a … more →
Passing parameters to dynamic query
zonixsoft wrote 1 year ago: visit http://www.zonixsoft.com (our official Website) Consider following queries 1. SELECT * FROM … more →
To get comma separated list of values of single field in SQL Server
zonixsoft wrote 1 year ago: Visit: http://www.zonixsoft.com (our official Website) A solution to get comma separated list of val … more →
DIFFERENCE and SOUNDEX in Transact-SQL
— 1 comment
zonixsoft wrote 1 year ago: visit: http://www.zonixsoft.com (our official Website) DIFFERENCE(string1, string2) Returns the diff … more →
Full Text Search in SQL Server 2005
— 1 comment
zonixsoft wrote 1 year ago: Visit: http://www.zonixsoft.com (our Official Website) Definition : Full text search is the search f … more →
MERGE Command in SQL Server
zonixsoft wrote 1 year ago: visit: http://www.zonixsoft.com (our official website) In SQL Server 2008, Microsoft introduces the … more →
CASE (Transact SQL)
zonixsoft wrote 1 year ago: Evaluates a list of conditions and returns one of multiple possible result expressions. CASE has two … more →
Paging in SQL Server
zonixsoft wrote 1 year ago: Visit: http://www.zonixsoft.com (our official Website) Web Application Performance (Paging in Sql Se … more →
Using TRY-CATCH to Rollback a Transaction in the Face of an Error
— 1 comment
zonixsoft wrote 1 year ago: Visit : http://www.zonixsoft.com (our official website) Error Handing in Sql Server 2005. The releas … more →
Passing lists to SQL server stored procedures
zonixsoft wrote 1 year ago: Visit : http://www.zonixsoft.com (our official wbsite) Article is about: The ability to pass “ … more →
Threading
— 2 comments
zonixsoft wrote 1 year ago: Visit: http://www.zonixsoft.com C# supports parallel execution of code through multithreading. A thr … more →
Some very special features of crystal reports
— 10 comments
zonixsoft wrote 1 year ago: Visit: .comhttp://www.zonixsoft Create a Watermark A watermark is a graphical or textual element tha … more →
Code Sample to Upload file to FTP Server
zonixsoft wrote 1 year ago: Visit: http://www.zonixsoft.com check out below code to upload file to FTP Server: /// <summary … more →
Icon in the Address bar Textbox in Browsers
zonixsoft wrote 1 year ago: Visit: http://www.zonixsoft.com (Short Cut) Icon in the Address bar Textbox in Browsers You have to … more →
Convert Date Formats :
— 1 comment
zonixsoft wrote 1 year ago: //For ex., Convert MM/dd/YYYY to dd/MM/yyyy string date = “03/27/2008″; //format is MM … more →
Maintaining Fck editor value during postbacks
zonixsoft wrote 1 year ago: Here is the code to maintain value of FckEditor value during postbacks, Write in Page_Load event, … more →
