Categories
Sql Server

INSERT Trigger in Sql Server

INSERT Trigger Works Sql Server INSERT TRIGGER is a trigger that execute itself whenever an INSERT statement inserts data into any table or view on which the trigger was configured. When an INSERT trigger fires itself, new rows are also added on both the trigger table and inserted table. The inserted table is a logical table […]

Categories
Sql Server

How To Delete All Rows From Table In SQL Server

How To Delete All Rows From Table In SQL Server Hi guys, in this tutorial i will let you know How To Delete All Rows From Table In SQL Server.If you are willing to delete all rows from your table in one go, and you want that transaction must be logged. Solution: Delete FROM TABLE Where PRIMARY_KEY_ is […]

Categories
Sql Server

What Is Sql Injection In Sql-Server And How Hackers Achieve It

What Is SQL Injection In SQL-Server SQL injection is a attack which consist some malicious code has been inserted into strings that are later passed to an instance of SQL Server for parsing and execution. Any procedure that constructs SQL statements should be reviewed for injection vulnerabilities because SQL Server execute all syntactically valid queries […]

Categories
Sql Server

How to hide system objects in Sql Server

How to hide system objects in Sql Server Many of us don’t like the existence of all the system tables, objects and stored procedures in SQL Server’s user interface. To get rid of these the system objects. Follow these steps:- Open Sql-Server Management Studio. Now click on the Tools.For reference please find image below. Click on image […]