Sql

By 04/05/2016 Read More →

Generate Pi Chart From MySQL Database In PHP

It is easy to create different types of beautiful dynamic pi charts and graphs in PHP using MySQL database. These different types of pi charts are generated automatically for us from MySQL database. In this tutorial i create a pi chart in PHP from MySQL database, for that purpose i have already created a database table […]

Posted in: PHP, Solutions, Sql
By 28/04/2016 Read More →

Sql Server Data Type For Storing Price Values

In most cases you want to storing a value which represents a price, amount or money in Microsoft Sql Server. Sql Server database offers different data types for storing money/price type data such as money, smallmoney, numeric(p,s) and decimal(p,s). But at this point it is important to decide that which data type is best for storing […]

Posted in: Solutions, Sql

How To Insert Non-English Characters In MySQL?

MySQL database is an open source dbms system. You can insert non-english unicode characters in it when you work with a web application which supports multi-lingual environment such as hindi, sindhi, urdu or arabic languages etc. Look at a following step to achieve this. Step: Set the character set or charset as utf8 and collation […]

Posted in: Solutions, Sql

SQL Server ntext vs nvarchar(MAX) Datatypes

SQL Server offers ntext and nvarchar(MAX) datatypes for storing multi lingual string based information/values. There are some difference between ntext and nvarchar(MAX) datatypes: The ntext datatype stores unicode string with maximum 2GB of data. The nvarchar(MAX) datatype stores unicode string with maximum 536,870,912 characters. The ntext datatype has many disadvantages such as it does not […]

Posted in: ASP.NET, Solutions, Sql

How To Insert Non-English Characters In SQL Server?

SQL Server offers nchar, nvarchar, nvarchar(max) and ntext datatypes for storing Non-English or Unicode characters/article posts into database table. By using above datatypes you can insert all characters/large blogs which has been spoken in universe such as hindi, sindhi, urdu, arabic, english etc. These datatypes are also recommended by Microsoft because these support many built-in […]

Posted in: ASP.NET, Solutions, Sql

SQL Server Data Type For Store Article Posts

SQL server offers several data types for storing different types of information in database. Some time we need to store a large article or blog post in a database table. For storing the large posts or articles we will use nvarchar(MAX) datatype because it supports maximum 536,870,912 characters. SQL Server nvarchar(MAX) data type supports many built-in […]

Posted in: ASP.NET, Solutions, Sql

What Is SQL?

SQL stands for Structured query language. It is a language which is used for accessing and manipulating the database. It is a standard language for all RDBMS (Relational database management systems) such as MS access, SQL server, MySQL etc. In other words it is a language which talks or communicates with database by issuing command statements. […]

Posted in: Sql

SELECT Statement In SQL

SELECT statement is a SQL clause. SELECT statement is also called retrieval statement. SELECT statement is used to select data from database and stored these data into tables as data sets. SELECT statement can be used in two ways as following. Syntax – 1: This is used for select only selected column(s) from entire database table. […]

Posted in: Sql
Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .