Microsoft SQL Server Help | SQL Queries

What is SQL Server?

Microsoft SQL Server is a relational database management system (RDBMS) for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions originally from Sybase.

Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an enterprise environment used to generate databases that can be accessed from workstations, the Internet(Web), or other media such as a personal digital assistant (PDA).

SQL Server 2000, SQL Server 2005 and SQL Server 2008 is a popular database server of Microsoft's Windows family.

Assignmenthelp.net provides SQL Queries help, SQL tutorials and Database online tutoring at affordable price to world wide students. Our different services provides you SQL Server Assignment Help, MySQL Assignment Help, MS Access Assignment Help, Oracle queries help, DB2 Assignment Help and other database systems. Expert database tutors of assignmenthelp.net also handle complex database queries on SQL Server, Oracle and MySQL.

For Example: Students can see through SQL statements, How to create, alter and drop table in three different RDBMS?

Create Statement

The Create Table statement is used to create a table in a database.

SQL	MYSQL	ORACLE
The CREATE TABLE statement is used to create a table in a database.	CREATE TABLE table_name (column_name1 data_type, column_name2 data_type,...);	Create table Book ( BookId integer, BookName varchar(30), Student_Sid integer, Amount integer, Primary Key (BookId), Foreign Key (Student_Sid) references Student(Sid));	Create table Book( BookId integer PRIMARY KEY, BookName varchar(30), Amount integer, Student_Sid integer references Student(Sid));
Creates an index on a table. Duplicate values are allowed.	CREATE INDEX index_name ON table_name(column_name);	CREATE INDEX index_name ON table_name(column_name);	CREATE INDEX index_name ON table_name(column_name);
Creates a unique index on a table. Duplicate values are not allowed.	CREATE UNIQUE INDEX index_name ON table_name(column_name);	CREATE UNIQUE INDEX index_name ON table_name(column_name);	CREATE UNIQUE INDEX index_name ON table_name(column_name);
Create View Syntax	CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition;	CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition;	CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition;

Drop Statement

Indexes, tables, and databases can easily be deleted / removed with the Drop statement.

SQL	MYSQL	ORACLE
It is used to delete a Table.	DROP TABLE Student;	DROP TABLE Student;	DROP TABLE Student;
It is used to delete a database.	DROP DATABASE database_name;	DROP DATABASE database_name	DROP DATABASE database_name
Delete the data inside the table only	TRUNCATE TABLE table_name;	TRUNCATE TABLE table_name;	TRUNCATE TABLE table_name;
The DROP INDEX statement is used to delete an index in a table.	DROP INDEX table_name.index_name;	ALTER TABLE table_name DROP INDEX index_name;	DROP INDEX index_name;

Alter Statement

The Alter Table statement is used to add, delete, or modify columns in an existing table.

SQL	MYSQL	ORACLE
Rename the table name.	ALTER TABLE table_name RENAME TO new_table_name;	ALTER TABLE table_name RENAME TO new_table_name;	ALTER TABLE table_name RENAME TO new_table_name;
Add a column in a table	ALTER TABLE table_name ADD column_name datatype	ALTER TABLE table_name ADD column_name datatype;	ALTER TABLE table_name ADD column_name datatype;
Delete a column in a table	ALTER TABLE table_name DROP COLUMN column_name;	ALTER TABLE table_name DROP COLUMN column_name;	ALTER TABLE table_name DROP COLUMN column_name
Change the data type of a column in a table	>ALTER TABLE table_name ALTER COLUMN column_name datatype;	ALTER TABLE table_name ALTER COLUMN column_name datatype;	ALTER TABLE table_name ALTER COLUMN column_name datatype;

To submit SQL Server assignments Click here

Sql Assignment Question