Notes
Notes - notes.io |
go
create database bilgisayardeneme
go
use bilgisayardeneme
go
create table musteri(id int identity (1,1) primary key , adi varchar(50))
go
create table siparis(sipNo int identity (1,1) primary key, musNoFk int foreign key references musteri(id),sipTar datetime)
go
create table urun(urunKodu char(3) primary key not null,urunAdi varchar(50),ozellik varchar(50))
go
create table sipDetay(sipNoFk int foreign key references siparis(sipNo),urunNo char(3) foreign key references urun(urunKodu))
go
alter table urun add urunTuru varchar(50)
go
alter table urun drop column urunTuru
go
alter table urun alter column ozellik varchar(20)
go
insert into urun values('185','Gözlük','8x')
go
insert into urun(urunKodu,urunAdi) values('847','Rayban')
go
update urun set ozellik=Null where urunKodu='847'
go
create table deneme(id int , ad varchar(50),soy varchar(50))
go
DELETE deneme WHERE id=1
go
select * from urun where urunAdi='Gözlük'
go
select ozellik from urun left join sipDetay on urun.ozellik=sipDetay.urunNo
go
create login Hüsnü with password='12345678'
go
create user Hüsnü for login Hüsnü
go
grant create table to Hüsnü
go
grant insert,update,delete to Hüsnü
go
grant select on musteri to Hüsnü
go
deny delete,insert on siparis to Hüsnü
go
revoke all on region to Hüsnü
go
CREATE VIEW denemeview AS
Select * From urun where urunKodu>='180'
select * from denemeview
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
