1.日期转换
-
mysql:
-
DATE_FORMAT(date,'%Y-%c-%d 00:00:00' )
-
sqlserver:
-
CONVERT(varchar(100),date,20)
2.字符串插入
-
mysql:
-
INSERT ( str, 1, 1, '' )
-
sqlserver:
-
STUFF ( str, 1, 1, '' )
3.字符串拼接
-
mysql:
-
SELECT group_concat( name SEPARATOR ';' ) FROM p WHERE xxx=xxx
-
sqlserver:
-
SELECT ';' + name FROM p WHERE xxx=xxx FOR XML path ( '' )