Change schema name in all tables, Procedures & Views in SQL database.
Sometimes We try to run database script of database from one server to another server, without removing schema suffix…
Sometimes We try to run database script of database from one server to another server, without removing schema suffix…
In this article, we will learn how to find sum of column’s value. This will be very helpful in situation where we calc…
Some time we want to perform some action after particular interval of time. Ex. redirect to other page after 5 sec . …
We use various constraints in database, which are very helpful to manage database.
We can delete tables from database one by one by using Query as well as using GUI. Some time we need to delete all ta…
Function cannot be used to perform action that can modify data ex. Insert, Update & Delete.
When we want to return table as a result, then we can use table valued functions. User defined Table Valued function…