SQL Query Analyzer merupakan sarana yang memiliki antarmuka grafis yang berfungsi untuk melakukan serangkaian aktivitas yang berhubungan dengan pemulihan dan pengoptimalan query-query di dalam database.
Aktivitas-aktivitas tersebut diantaranya :
– Melakukan query pada database SQL Server dengan menggunakan perintah-perintah SQL
– Menampilkan hasil query dengan grid atau teks
– Melihat representasi grafik dari langkah-langkah untuk menjalankan query
– Menjalankan analisa kinerja indeks
– Mengakses help online untuk bahasa Transact SQL
– Menjalankan skrip Transact-SQL dari prosedur-prosedur yang tersimpan
Dengan fasilitas Query Analyzer maka perintah-perintah SQL dapat dieksekusi secara langsung.
Berdasarkan fungsinya perintah SQL dibagi ke dalam dua kategori yaitu DDL(Data Definition Language) dan DML(Data manipulation Language).
Daftar Pustaka
Michael Otey and Paul Conte, “SQL Server 7 Developper’s Guide”, Berkeley New York St. Louis San Fransisco
Adi Kurniadi, “SQL Server 7”, PT Elex Media Komputindo 2001
Inixindo, “Konsep MS-SQL7”, Inixindo 1998
Vieira, Robert, “Professional Sql Server 7.0 Programming”
i miss u
Hello.This post was extremely interesting, particularly because I was browsing for thoughts on this issue last Sunday.
I’ve recently started a weblog, the information you provide on this website has helped me tremendously. Thanks for all your time & work.
I’m still studying from you, but I’m improving myself. I definitely love studying every part that’s written in your blog.Maintain the tales coming. I liked it!
My partner and I really loved reading this blog post, I was simply itching to know do you trade featured posts? I’m at all times looking for somebody to make trades with and merely thought I would ask.
I’m nonetheless learning from you, but I’m enhancing myself. I definitely love studying every thing that is written on your blog.Hold the stories coming. I liked it!
Excellent writing and genuinely aids with learning the subject better.
Finally, got what I was looking for!! I definitely enjoying every little bit of it. Glad I stumbled into this article! smile I have you saved as a favorite to check out new stuff you article.
Intriguing article. I know I’m a little late in posting my comment but the article was to the point and just the information I was looking for. I can’t say that I agree with all you mentioned but it was emphatically fascinating! BTW…I found your site through a Google search. I’m a frequent visitor to your blog and will return again soon.
These kind of post are always inspiring and I prefer to read quality content so I happy to find many good point here in the post, writing is simply great, thank you for the post
Well, this is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvellous job!