Generally, most programming languages process statement from top to bottom. But SQL Server is different in order of execution, SQL...
Read More
Find Free Space by Database
Using this query you can find out the free space available for each database. --create a Table variable to store database informatio...
Read More
Create Data Dictionary in SQL Database
This query will create a Data dictionary of a database which can be very helpful while doing the documentation of a project. select...
Read More
Different ways to create a foreign key in an existing table
Here are the 3 different ways to add a Foreign Key in an existing table:- By using ADD CONSTRAINT with update and delete cascade co...
Read More
Find a Keyword in all Stored Procedures or whole Database
Find all Stored Procedures that reference a Column, Table Name or any keywo rd. Using this Query You can search for a column/table nam...
Read More
Subscribe to:
Posts
(
Atom
)