Tag Archives: SQL Server

SQL REVERSE

SQL REVERSE function is used to return reverse of a string. It’s supported by MS SQL Server, MySQL. Oracle supports it too, but maybe not in the documents.

SQL Functions Also tagged , , Leave a comment

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?

SQL Advanced Leave a comment

SQL LEFT Function

SQL LEFT() function is used to get left part of a string with the length of specified number. It is supported by MySQL, MS SQL Server, Access, but not by Oracle.

SQL Functions Also tagged , Leave a comment

SQL SPACE

SQL SPACE() function is used to return space characters, the number of the characters is indicated by the interger parameter. It is supported by MySQL and MS SQL Server, but not Oracle.

SQL Functions Also tagged , Leave a comment

SQL DATENAME

SQL DATENAME() is a SQL Server function used to return the name or value of the specified datepart of the a date.

SQL Functions Also tagged Leave a comment

SQL CONVERT

The SQL CONVERT() is a SQL Server function which is used to convert a data type to another data type in general. We can also use this function to convert a date/time expression to different formats, or convert a formatted date/time string to date expression.

SQL Functions Also tagged Leave a comment

SQL DATEDIFF

The SQL DATEDIFF() function is used to get the date/time difference of 2 date expressions. It is supported by both SQL Server and MySQL, but the syntax is different.

SQL Functions Also tagged , Leave a comment

SQL DATEADD

The SQL DATEADD() function is used to add or subtract a time interval to a date.

SQL Functions Also tagged Leave a comment