>>>>>>>>>>>>>>>>>>>>>>
1. The first thing to say is in, it means you need to check the conditions
In a range or not a single determined value ;
Eg:select *from Student
where Dname in (' Computer department ', ' Electrical Engineering Department ')
>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>
2. The so-called fuzzy query means to use some special characters instead of the word
Eg:select *from Student
Where name like ' meter% '
_ just represents a character,% represents a number of
[] It will be a little more complicated, in which the line
The beginning, the end, the middle, the ends
>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>
3.sql Several common functions for working with DateTime
YY-MM-DD Hh-mm-ss
Extract Month : int x =datepart(mm, date)
Calculate Age: Or the difference
DateDiff (YY,DATE1,DATE2)
>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>
complex applications for SQL Server 2008