Example:
Update FIRST_NAME to 'JOE' in STUDENT table for the student whose Id is 1 .
Query:
Update FIRST_NAME to 'JOE' in STUDENT table for the student whose Id is 1 .
Query:
UPDATE STUDENT
SET FIRST_NAME = 'JOE'
WHERE STUDENT_ID =1
Categories
- Examples (15)
- INTRODUCTION (14)
- Join in SQL Server (8)
- Miscellaneous (5)
- SQL SERVER COMMANDS (29)
- SQL SERVER DDL COMMANDS (3)
- SQL SERVER DML COMMANDS (8)
- SQL SERVER Error Messages (4)
- SQL SERVER FUNCTIONS (10)
- SQL SERVER GENERAL QUESTIONS (28)
- SQL SERVER GENERAL SCENARIOS (1)
- SQL Server Installation (1)
- SQL SERVER Interview Questions (8)
- sql server performance tuning tips (3)
- SQL SERVER Tutorial for the Beginners (1)
- Stored Procedures (20)
- Templates (6)
- white papers (1)
Archives
-
▼
2012
(144)
-
▼
August
(26)
- SQL SERVER OBJECT TEMPLATES -- TABLE
- SQL SERVER OBJECT TEMPLATES -- VIEW
- SQL SERVER OBJECT TEMPLATES -- STORED PROCEDURE
- SQL SERVER OBJECT TEMPLATES -- INSERT SCRIPT
- SQL SERVER OBJECT TEMPLATES -- INDEX CREATION
- SQL SERVER OBJECT TEMPLATES -- FUNCTION
- @@SERVERNAME
- @@VERSION
- @@LANGUAGE
- @@Functions in SQL SERVER
- Database Creation Example
- Drop database Example
- Create database example by defining size etc.,
- USE Clause Example
- Create Table Example
- Insert data Examples
- Example for Update data in a table
- Example for Deleting data from a table based on a ...
- Example for Deleting complete data from table
- Example for Truncate table
- Example for Inserting Data into a table
- Example for creating a simple stored procedure
- Example for creating a stored procedure with an in...
- Example for Creating a stored procedure with input...
- Examples in SQL SERVER
- Temporary Tables
-
▼
August
(26)
About
This blog is created to provide complete solutions for all possible problems in SQL SERVER. It contains SQL SERVER Performance techniques, SQL SERVER Interview questions and complete SQL Tips.