Skip to content

Instantly share code, notes, and snippets.

CREATE DATABASE ismerdatabase
GO
CREATE SCHEMA Employeess
GO
CREATE TABLE HumanResourcesEmployeess(
HRid INT NOT NULL PRIMARY KEY IDENTITY(1,1),
HRname NVARCHAR NOT NULL,
HRsurname NVARCHAR NOT NULL,
HRSSN INT NOT NULL UNIQUE)
CREATE TABLE ITEmployeess(
create database sistem1
go
use sistem1
go
create table [dbo].[marka](
marka_no int not null PRIMARY KEY IDENTITY(1,1),
marka_isim nvarchar(50) not null)
create table [dbo].[urun](