Closed sulmar closed 1 year ago
use master
create database CSharpCourseDb
GO
use CSharpCourseDb
create table dbo.Members ( MemberId int primary key, Firstname nvarchar(50) not null, Company nvarchar(50) not null, Position nvarchar(50) not null, Salary decimal null, [Date] datetime not null )
insert into dbo.Members (MemberId, Firstname, Company, Position, Salary, [Date]) values (1, 'Damian','Abc','developer',100.99,'2023-07-27'), (2, 'Michał','Abc','developer',200.50,'2023-07-27'), (3, 'Michał','Abc','developer',300.54,'2023-07-27'), (4, 'Agnieszka','Abc','developer',100.99,'2023-07-27'), (5, 'Marcin','Sulmar','instructor',50.01,'2023-07-27')
- Weryfikacja ``` sql select * from dbo.Members
create database CSharpCourseDb
GO
use CSharpCourseDb
create table dbo.Members ( MemberId int primary key, Firstname nvarchar(50) not null, Company nvarchar(50) not null, Position nvarchar(50) not null, Salary decimal null, [Date] datetime not null )
insert into dbo.Members (MemberId, Firstname, Company, Position, Salary, [Date]) values (1, 'Damian','Abc','developer',100.99,'2023-07-27'), (2, 'Michał','Abc','developer',200.50,'2023-07-27'), (3, 'Michał','Abc','developer',300.54,'2023-07-27'), (4, 'Agnieszka','Abc','developer',100.99,'2023-07-27'), (5, 'Marcin','Sulmar','instructor',50.01,'2023-07-27')