Tag: zonixsoft

User Interface (UI) and User Experience (UX) design

User Interface (UI) and User Experience (UX) design are two critical components of any digital product. UI design is concerned with the visual aspects of a product, such as the layout, color scheme, typography, and other design elements. UX design, on the other hand, is concerned with how users interact with a product and how […]

Google Chrome OS

Google is launching Chrome OS. Google is saying that the modern computer user spends so much time working with Web-based resources that the main control system for the computer should be the browser, not the operating system. Furthermore, Google declared that the Chrome OS experience will bear little resemblance to existing way that users interact with their […]

Tips for Creating a better E-Commerce Application

E-Commerce, A name started few years back and now ruling the world. Most of the companies started their E-Commerce portals to sell products online to increase their sales and some are even only online portals they don’t have off line stores and they sell some one else’s products. Now a days people want the products […]

Tips for Creating a better E-Commerce Application

E-Commerce, A name started few years back and now ruling the world. Most of the companies started their E-Commerce portals to sell products online to increase their sales and some are even only online portals they don’t have off line stores and they sell some one else’s products. Now a days people want the products […]

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 against a single connection. But, execution of multiple batches with MARS does not mean like simultaneous execution of operations. In previous versions […]

How Big is google’s database

Visist : https://zonixsoft.com (Our Official Website) Google search crawler uses 850 TB of information, so that’s the amount of raw data from the web. Google Analytics uses 220 TB stored in two tables: 200 TB for the raw data and 20 TB for the summaries. Google Earth uses 70.5 TB: 70 TB for the raw […]

The real difference between SQL Server and Oracle

Visit : https://zonixsoft.com (our Official website) For years now there’s been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that’s not really where the real importance lies. Sure, functionality is a part of it because your database should be able to do what […]

UPDATE Based Off of A Table

visit : https://zonixsoft.com (our official website)  INSERT offers the ability to insert into a table based upon a SELECT statement with the following syntax: INSERT INTO [TABLEA] ([FIELDA],[FIELDB],[FIELDC])         SELECT [FIELDA],[FIELDB],[FIELDC] FROM [TABLEB]   there are time where you may want to do a similar approach with UPDATE. Here is the syntax to do that […]

Passing parameters to dynamic query

visit https://zonixsoft.com (our official Website)   Consider following queries 1. SELECT * FROM @tablename 2. SELECT @colname FROM tbl 3. SELECT * FROM tbl WHERE x IN (@list) 4. SELECT @Cnt=Count(*) FROM tbl WHERE x IN (@list)   For the first query, it will give error ‘Must declare the table variable “@tablename”‘ if @tablename is […]

To get comma separated list of values of single field in SQL Server

Visit: https://zonixsoft.com (our official Website) A solution to get comma separated list of values of single field of a database table   You can use the following code to get the comma separated list of values of a single field of a table:   DECLARE @commaSeparatedVal AS VARCHAR(4000) SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +‘,’,”) + CONVERT(VARCHAR,[SKU]) […]