Simple details that those programmers will forget-db, forget details-db

Simple details that those programmers will forget-db, forget details-db

1. Date plus dateadd (day, 1, '2017-12-31 ')

2. In the first few sqlervers, you can use top 1 mysql. None of them can only use limit.

3. The current date sqlserver is getdate () mysql is now () curdate () curtime ()

4. The identifier qualifier sqlserver is [] mysql is''

5. String addition sqlserver is + mysql is concat ()

6. Is it null? sqlserver is isnull () mysql is ifnull ()

7. the random function sqlserver is newid () mysql is uuid ()

8. The newly inserted idsqlserver is @ IDENTITY mysql is last_insert_id ()