In MS SQL Server, there are some data types of string, like char, nchar, varchar, nvarchar. What’s the difference among them?
SQL Advanced
SQL Clauses, Expressions …
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.
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.
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.
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.
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 |
| … | ||||