1
2
3
4
5
6
7
8
9
SELECT * 
FROM mitarbeiter m 
join 
        (SELECT mnr as x, count(thema) as ANZAHL FROM 
                (SELECT k.mnr, b.thema FROM
                kundenbetreuer k right
                join betreut b on 
                (k.mnr = b.betreuer) 
                GROUP BY k.mnr, b.thema) 
 ...

1
select * from dbasicos;

1
select * from tbl;

1
2
3
4
5
6
7
8
9
' List Windows Product Activation Status
 
 
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
 
Set colWPA = objWMIService.ExecQuery _
    ("Select * from Win32_WindowsProductActivation")
 ...

1
select * from ecom;

1
2
3
create table tbl(str varchar(20));
insert into tbl values('Hello world!');
select * from tbl;

1
2
3
4
CREATE databse MyDB
create table student(Num integer, name char(20))
insert into student values(01, 'tanaka')
insert into student values(02, 'satou')

1
2
3
4
CREATE TABLE livros (id INT, nome TEXT); 
INSERT INTO livros VALUES(1,'livro 1');
INSERT INTO livros (2,'livro 2');
--INSERT INTO livros SET id=3,nome='livro 3'; 

1
2
3
4
CREATE TABLE livros (id INT, nome TEXT); 
INSERT INTO livros VALUES(1,'livro 1');
--INSERT INTO livros (2,'livro 2');
INSERT INTO livros SET id=3,nome='livro 3'; 

1
2
3
create table tbl(str varchar(20));
insert into tbl values('Hello world!');
select * from tbl;

1
2
3
4
5
6
7
8
9
 
CREATE TABLE Vendors
(
Vendor_ID varchar (7) not null PRIMARY KEY,
Name varchar (10) not null,
Order_Address varchar (5) not null,
Order_Street varchar (10) not null,
Order_City varchar (15) not null,
Order_State char (2) not null,
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vendors
(
Vendor_ID varchar (7) not null PRIMARY KEY,
Name varchar (10) not null,
Order_Address varchar (5) not null,
Order_Street varchar (10) not null,
Order_City varchar (15) not null,
Order_State char (2) not null,
Order_Zip int not null,
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vendors
(
Vendor_ID varchar (7) not null PRIMARY KEY,
Name varchar (10) not null,
Order_Address varchar (5) not null,
Order_Street varchar (10) not null,
Order_City varchar (15) not null,
Order_State char (2) not null,
Order_Zip int not null,
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vendors
(
Vendor_ID varchar (7) not null PRIMARY KEY,
Name varchar (10) not null,
Order_Address varchar (5) not null,
Order_Street varchar (10) not null,
Order_City varchar (15) not null,
Order_State char (2) not null,
Order_Zip int not null,
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vendors
(
Vendor_ID varchar (7) not null PRIMARY KEY,
Name varchar (10) not null,
Order_Address varchar (5) not null,
Order_Street varchar (10) not null,
Order_City varchar (15) not null,
Order_State char (2) not null,
Order_Zip int not null,
 ...

1
2
3
4
5
6
7
8
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
('ST','Semi-Tracter Trailor');
 ...

1
2
3
4
5
6
7
8
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
('ST','Semi-Tracter Trailor');
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
create table Names(id int, Fname varchar(40), Lname varchar(40));
insert into Names values(1, 'John', 'Doe');
insert into Names values(2, 'Barry', 'Singer');
insert into Names values(3, 'John', 'Doe');
insert into Names values(4, 'James', 'Brown');

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE DATABASE Maintenance
ON 
(NAME = 'Maintenance',
FILENAME = 'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Maintenance.mdf',
SIZE = 20,
MAXSIZE = 100,
FILEGROWTH = 5)
LOG ON
(NAME = 'Maintenance_Log',
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Vehicle_Type
(
TypeID char (3) not null PRIMARY KEY,
[Description] varchar (100) not null
);
GO
 
INSERT into Vehicle_Type VALUES
('TT','Tracter Trailor'),
 ...

1
2
3
4
5
6
7
8
9
CREATE TABLE Maintenance_Work_Order
(
Work_Order_ID varchar (5) not null PRIMARY KEY,
VIN_Number varchar (17) not null 
FOREIGN KEY REFERENCES Vehicles (VIN_Number),
Maintenance_Type_ID varchar (5) not null 
FOREIGN KEY REFERENCES Maintenance_Code(Maintenance_Type_ID),
Assignment_To varchar (9) not null,
Date_Started date not null,
 ...

1
2
3
create table tbl(str varchar(20));
insert into tbl values('Hello world!');
select * from tbl;

1
2
3
create table tbl(pk int(5) primary key,str varchar(20), level_of_boredom char(15));
insert into tbl values(12345,'Sergio','over 9000');
select * from tbl where pk=12345;