Sql Server

About Sql Server

What is Sql?

Sql means Structured Query Language.It is interface of the Relational Database Management System[RDBMS].It is used for to store the client information in server side for providing security to user data.The data is stored in the form of tables. Table is collection rows and columns.In this servers we are using different type of commands like create,insert,update,delete,select,alter.

In SqlServer,we are providing security to database by using 2 types of authentications.

1)Windows Authentication: it doesnot Provide the security to database.Every user can use this database directily.

2) Server Authentication: By using this authentication, Only perticular user can access this database.it provides the security to data on userid and password.

Create : It is used for to create table.

Command : create table [tablename] (name varchar(50),id int);

Insert : It is used for to insert the data in a database .

Command: Insert into [tablename] values('data','data');

Update: It is used for to update table data.

Command :update [tablename] set [columnname]=value where columnname=value;

Delete: It is used for to delete table data but not memory.

Command: delete from [tablename] where [columnname]=value;

Select: It is used for to retriving the data from database.

Command: Select * from [tablename];

Alter: It is used for to modify the table.

Command: alter table [tablename] add column [columnname datatype(size)] ;

Command: alter table [tablename] drop [columnname];

Sql server