Category Archives: Sql Server

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

SQL Select Statement

SQL Select Statement Hi friends, in this post we will learn about SQL Select Statement or you can say Select Query to get data from SQL server tables. SQL Select Statement are used to fetch data rows from table. In SQL Select Query we can also add conditions to get conditional data only. Earlier we had discussed about SQL Insert Statement, Drop Table

SQL Insert Statement

SQL Insert Statement Hi friends, in this post we will learn about SQL Insert Statement or you can say Insert Query to insert data into SQL server tables. SQL Insert Statement are used to add new data rows into table. Earlier we had discussed about Drop Table SQL Server, Rename Table in SQL Server, Create Table SQL Server, Schema

Drop Table SQL Server

Drop Table SQL Server Hi friends, in this post we will learn how to Drop Table SQL Server. Drop table removes all data, indexes, triggers, constraints, and permission specifications for that table. Earlier we had discussed about Rename Table in SQL Server, Create Table SQL Server, Schema In SQL Server, SQL Server Operators, Data Type in SQL Server and Drop-Delete SQL Server

Rename Table in SQL Server

Rename Table in SQL Server Hi friends, in this post we will learn to Rename Table in SQL Server. Renaming a table in SQL server sometimes required as we do require same columns and data, with a different name. We can not use ALTER statement to rename table in SQL server. Earlier we had discussed

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