SQL Stored procedure are the set of logically group of SQL statement which are grouped to perform a specific task.
Advantages of SQL Stored Procedure
Continue reading
Tag: SQL Database
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used
Share this:
T-SQL script to find the growth size of database files
Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE
Share this:
How to restore database backup in SQL SERVER
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In
Share this:
How to take Database backup in SQL SERVER
Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable
Share this:
Database Creation using SQL Sever Management Studio (SSMS)
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command.
Share this:
Database Creation using Create Database command
In SQL Server, database can be created by 2 ways:- Using Create Database command Using SQL Sever Management Studio (SSMS).
