Archive for the Category: SQL Advanced

The Difference Among char, nchar, varchar, nvarchar in MS SQL Server

In MS SQL Server, there are some data types of string, like char, nchar, varchar, nvarchar. What’s the difference among them?

Tagged Leave a comment

SQL Hosting

SQL hosting is the hosting that provides the SQL database services. It has many SQL databases in the SQL hosting market, and the most popular are MySQL, MS SQL Server, MS Access and Oracle.

Leave a comment

SQL Replication

SQL Replication technology is designed to copy and distribute database data and objects among different databases and to perform synchronization among them. By using SQL replication, you can distribute your database data to different locations, as many as you need.

Leave a comment

Data Type Differences Between SQL Server and Oracle

This article is used to gather data type differences information for people who are porting SQL from SQL Server to Oracle or vise versa. The differences are list in the following table. If you have more to put into, please leave a comment here and we will include it in the table.

4 Comments

Point In Polygon

The Point In Polygon problem asks that how to find if a given point lies within a polygon. Now we have an SQL solution for this problem.

10 Comments

SQL Select Top

Table: Employees EmployeeId FirstName LastName Department Salary 203 Mary Fox Finance 78000 204 Joe Lanyon Finance 45800 205 Sally Daff Finance 57000 206 Grace Salter Finance 62000 302 James Band Development 75000 303 Dona Earl Development 55000 304 Tony Oakes Development 49000 …

Leave a comment