How to delete table values in sql server 2008 example / delete query in sql server

Introduction:

This article is helps to delete table values using sql server in 2008 R2.

Method 1:

DELETE FROM [dbo].[STUDENTDETAILS] WHERE <Search Conditions,,>

GO

Example:

DELETE FROM [dbo].[STUDENTDETAILS] WHERE ID=3

GO

SELECT * FROM STUDENTDETAILS

Method 2:

Step1:

Expand TableàTable àRight ClickàEdit Top 200 Rows

Step2:

Select particular rowàRight Clickàselect Delete optionàclick ok

Read More →

How to update table values in sql server 2008 example / sql server update query

Introduction:

This article is helps to update table values using sql server in 2008 R2.

Method 1:

UPDATE [dbo].[STUDENTDETAILS]  SET [ID] = <ID, int,>,[NAME] = <NAME, varchar(20),>,[GENDER] = <GENDER, varchar(6),>,[DEPARTMENT] = <DEPARTMENT, varchar(50),> WHERE <Search Conditions,,>

GO

Example:

UPDATE STUDENTDETAILS SET DEPARTMENT='ECE' WHERE ID=1

UPDATE STUDENTDETAILS SET DEPARTMENT='EEE' WHERE ID=2

UPDATE STUDENTDETAILS SET DEPARTMENT='CSE' WHERE ID=3

GO

SELECT * FROM STUDENTDETAILS

Method 2:

Step1:

Expand TableàTable àRight ClickàEdit Top 200 Rows

 Step2:

Enter values in table column

Read More →

How to insert table values in sql server 2008 R2/ sql insert statement

Introduction:

This article is helps to insert table values using sql server in 2008 R2.

Method 1:

INSERT INTO [STUDENTDETAILS([ID],[NAME],[GENDER],[DEPARTMENT])VALUES(<ID, int,>,<NAME, varchar(20),>,<GENDER, varchar(5),>,<DEPARTMENT, varchar(50),>)

Example:

INSERT INTO STUDENTDETAILS ([ID],[NAME],[GENDER],[DEPARTMENT])VALUES(1,'Newton','male','CSE')

INSERT INTO STUDENTDETAILS ([ID],[NAME],[GENDER],[DEPARTMENT])VALUES(2,'Amita','Female','IT')

INSERT INTO STUDENTDETAILS ([ID],[NAME],[GENDER],[DEPARTMENT])VALUES(3,'Allvin','male','MECH')

GO       

SELECT *  FROM STUDENTDETAILS

Method 2:

Step1:

Expand TableàTable àRight ClickàEdit Top 200 Rows

  Step2:
Enter values in table column

Read More →

How to create table in sql server / Table creation in sql server

Introduction:

This article is helps to create new table using sql server in 2008/2008 R2.

Now create new table for our own way

Method 1:

Syntax:

CREATE TABLE TABLENAME(

COLUMNNAME1 DATATYPE(SIZE),

COLUMNNAME2 DATATYPE(SIZE),

…)

Example:

CREATE TABLE STUDENTDETAILS(

ID INT,

NAME VARCHAR(20),

GENDER VARCHAR(5),

DEPARTMENT VARCHAR(50)

)

Method 2:

Step1:

Expand DatabaseàTable àRight ClickàNew Table

Step2:

Enter Column name and data type (example INT, VARCHAR, DATETIME etc..,) and size.

Step3:

Press Ctrl+Sà Enter table nameàClick Ok

Step4:

Table can be created

Read More →

Drop / delete database in sql server /How to drop database in sql server 2008

Introduction:

This article is helps to delete database using sql server in 2008/2008 R2.

Method 1:

DROP DATABASE  DATABASENAME

Example:

USE MASTER

GO

DROP DATABASE  ASP_DOTNET

GO

Method 2:

Step1:

DatabaseàRight ClickàDelete

Step 2:

Please below checkbox Select/Check close existing connections

Click OK.  Now delete database successfully.

Read More →

How to Create new database in sql server 2008 / how to get values in datatable

Introduction:

This article is helps to create new database using sql server in 2008/2008 R2.

System databases are Master,Model,msdb,tempdb.

Now create new database for our own way

Method 1:

CREATE DATABASE DATABASENAME

Example:

CREATE DATABASE ASP_DOTNET

GO

Method 2:

Step1:

Database àRight Click à New Database

 Step 2:

Enter database Name and click OK

Step 3:

Create new database then using the such as table ,view, functions and Procedures etc..,

Read More →