Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...

DECLARE @asciichars TABLE (dec_value TINYINT NOT NULL, char_value AS CHAR(dec_value) COLLATE Latin1_General_CS_AS PERSISTED NOT NULL) --Fill in table var with numbers from 128 to 255 {extended ASCII ...

Since 1998, SQL injection were started. So many ways of doing SQL injection on different type of database. Attacks are happened on data-driven web application for exploiting the data of the server.

So, in order to prevent database from SQL Injection Attack, we propose a model, which is implemented with SNORT and HONEYPOT. Also data was encrypted with ASCII value.