Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

Create Table SQL Server

Create Table SQL Server Hi friends, in this post we will learn to Create Table SQL Server. Creating table in SQL Server is very easy. Tables consist rows and columns, columns name specify the name of columns and rows contains data in them. Column has data_type parameter which specifies what type of data the column can hold

Schema In SQL Server

Schema In SQL Server What is schema? Hi friends, in this post we will learn about Schema in SQL Server. A schema is a container that holds tables, views, procedures, and so on. It is inside a database. The server is the outermost box, and the schema is the innermost box. In earlier post we

SQL Server Operators

SQL Server Operators Hi friends, in this post we will discuss about SQL Server Operators. Operator is a symbol specifying an action performed on one or more expressions. Operators are used to specify conditions in an SQL statement. Following are operators in SQL Server: Arithmetic Operators: Arithmetic operators used to perform mathematical operations on two expressions. Operator

Data Type in SQL Server

Data Type in SQL Server Hi friends, in this post we will learn about Data Type in SQL Server. A data type is an attribute that specifies the type of data that the object can hold: integer data, character data, monetary data, date and time data, binary strings, and so on.We can also define our own data

Drop-Delete SQL Server Database Using Management Studio or Query

Drop-Delete SQL Server Database Using Management Studio or Query Hi friends, in this post we will learn how to Drop-Delete SQL Server Database Using Management Studio or Query. Sometime we have a requirement of deleting database, we can do it by two ways. Using SQL Server management studio and Query. We will demonstrate you both ways.

Alter-Rename SQL Server Database Using Management Studio or Query

Alter-Rename SQL Server Database Using Management Studio or Query Hi friends, in this post we will learn how to Alter-Rename SQL Server Database Using Management Studio or Query. Sometime we have a requirement of changing database name, we can do it by two ways. Using SQL Server management studio and Query. We will demonstrate you both