SQL infuse flaw is contacted completely (3)

Infuse of the 2nd section, SQL is commonly used function
Have the person of SQL language foundation, in SQL infuse when successful rate compares unfamiliar the person is a lot of taller. We are necessary to raise our SQL level, especially a few commonly used function and command.
Access: Asc(character) SQLServer: Unicode(character)
Action: Return the ASCII code of some character

Access: Chr(number) SQLServer: Nchar(number)
Action: As contrary as Asc, according to ASCII the code returns character

Access: Mid(string, n, l) SQLServer: Substring(string, n, l)
Action: Return string from N the length since character is L child string, namely N arrives the string between N L

Access: Abc(number) SQLServer: Abc (number)
Action: The absolute value that returns a number (can use when guessing solution Chinese character)

Access: A Between B And C SQLServer: A Between B And C
Action: Judge A whether bound between B and C

Processing technique of the 3rd section, Chinese
Chinese character is being come up against in infuse is constant some thing, some people come up against Chinese character to think back out. The encode that wants pair of Chinese only actually understands somewhat, "Chinese dread disease " can overcome very quickly.
Say a bit general knowledge first:
In Access, the ASCII code of Chinese may appear negative number, absolute value is taken with Abs() after taking out this negative number, chinese character character is changeless.
In SQLServer, the ASCII of Chinese is plus, but because be the two-step encode of UNICODE, cannot gain ASCII yard with function Ascii() , must return Unicode value with function Unicode () , reoccupy Nchar function acquires corresponding Chinese character.
Understood above after 2 o'clock, feel Chinese guesses solution to also follow English actually about the same? Want the attention, range that guess solution besides use function a bit bigger outside, the method is different of it doesn't matter.
(Into rank piece be over)
View a learn the rudiments of a subject piece and into rank piece hind, practice slightly, the website with broken common solution is to be no problem. But if come up against a watch to rank a name to be not guessed,arrive, or program author filtered a few special character, how to raise the successful rate of infuse? How to improve the efficiency that guess solution? Ask everybody to look downward then advanced piece.
The first, use a system to express infuse SQLServer database
SQLServer is the database system with a powerful function, also have close connection with the operating system, this brought very big convenience to developer, but on the other hand, also provided a diving board for infuser, we see a few particular case first:
Previous12 Next