Mysql and SQL Server use difference comparison

Query the first 100 data

#mysql Select *  from  - ; #sqlserver Select Top  - *  from table_name;

From the database. Table Positioning table

#mysql写法: library name. Table name Select  from where userName='boss'#Sqlserver写法: library name. dbo. Table name; or: library name. Table name (note: Use two points in the middle)Selectfromwhere userName='boss  '

Get time

MySQL notation: now () SQL Server: getdate ()

Join query

&Select A.*from as leftjoin as  on =

Mysql and SQL Server use difference comparison