Page 15 - SQL
P. 15
Chapter 49: SQL Group By vs Distinct 163
Examples 163
Difference between GROUP BY and DISTINCT 163
Chapter 50: SQL Injection 165
Introduction 165
Examples 165
SQL injection sample 165
simple injection sample 166
Chapter 51: Stored Procedures 168
Remarks 168
Examples 168
Create and call a stored procedure 168
Chapter 52: String Functions 169
Introduction 169
Syntax 169
Remarks 169
Examples 169
Trim empty spaces 169
Concatenate 170
Upper & lower case 170
Substring 170
Split 171
Stuff 171
Length 171
Replace 172
LEFT - RIGHT 172
REVERSE 173
REPLICATE 173
REGEXP 173
Replace function in sql Select and Update query 173
PARSENAME 174
INSTR 175
