LIVRE : Sqlserver - Création des bases des données pour des entreprises
Introduction & Détails
Chapter 1: Getting started with Microsoft
SQL Server
Version Release Date
SQL Server 2017 2017-10-01
SQL Server 2016 2016-06-01
SQL Server 2014 2014-03-18
SQL Server 2012 2011-10-11
SQL Server 2008 R2 2010-04-01
SQL Server 2008 2008-08-06
SQL Server 2005 2005-11-01
SQL Server 2000 2000-11-01
Section 1.1: INSERT / SELECT / UPDATE / DELETE: the basics
of Data Manipulation Language
Data Manipulation Language (DML for short) includes operations such as INSERT, UPDATE and DELETE:
-- Create a table HelloWorld
CREATE TABLE HelloWorld (
Id INT IDENTITY,
Description VARCHAR(1000)
)
-- DML Operation INSERT, inserting a row into the table
INSERT INTO HelloWorld (Description) VALUES ('Hello World')
-- DML Operation SELECT, displaying the table
SELECT * FROM HelloWorld
-- Select a specific column from table
SELECT Description FROM HelloWorld
-- Display number of records in the table
SELECT Count(*) FROM HelloWorld
-- DML Operation UPDATE, updating a specific row in the table
UPDATE HelloWorld SET Description = 'Hello, World!' WHERE Id = 1
-- Selecting rows from the table (see how the Description has changed after the update?)
SELECT * FROM HelloWorld
-- DML Operation - DELETE, deleting a row from the table
DELETE FROM HelloWorld WHERE Id = 1
-- Selecting the table. See table content after DELETE operation
Qui sommes-Nous ?
Tutoriel Populaire
PHOTOSHOP 3: TELECHARGER ET INSTALLER ADOBE PHOTOSHOP CC 2020 GRATUITEMENT
Tutoriel Populaire
POURQUOI ACTIVE WINDOWS AVCE KMSPICO ET COMMENT
Soutenez notre travail !
Nos ressources vous sont utiles ? Aidez-nous à faire plus ! Votre soutien est essentiel pour la création de nouveau contenu.
Faire un DonSpécifications Techniques
- Faculté/Domaine : Gestion de Base des données
- Institut : GoalKicker.com
- Année d'édition : 2022
- Garant : Russell Eyenga
- Format : pdf
- Téléchargements : 1,294