Search This Blog

Mengapa Menggunakan SQL Server

Dalam membangun aplikasi proses produksi dan inventory control ini penulis menggunakan Database server SQL Server 2000 dengan alasan:

1. SQL Server mudah digunakan.

2. SQL Server mendukung batch processing yaitu proses CommitTrans dan RollbackTrans. Jika kita sering melakukan update data lebih dari satu tabel dan lebih dari satu record, maka fitur ini sangat membantu dan mempermudah proses update data

3. Referensi mudah didapat

4. Tidak terlalu membutuhkan resource yang besar

5. Mendukung Store Procedure dan Trigger. Store procedure dapat mempersingkat penulisan program komputer karena kita tidak harus menulis berulang-ulang perintah insert,update dan delete pada aplikasi yang kita bangun. Kita tinggal memanggil Store Procedure yang kita buat dan mengirimkan parameter data ke SQL Server.

6. Backup Restore mudah digunakan

7. Koneksi ke Microsoft Access sangat mudah, yaitu dengan menggunakan ODBC driver kemudian tabel-tabel dari SQL Server 2000 dapat langsung dibuka melalui MS-Access dengan menggunakan fitur Link Table

7 comments:

sheela rajesh said...

You have great sense of knowledge which is proven from this article.kindly update more and more in future.
Hadoop Training in Chennai
Big data training in chennai
big data training in velachery
JAVA Training in Chennai
Python Training in Chennai
SEO Training in Chennai
Hadoop training in chennai
Big data training in chennai
big data training in velachery

Soulblu said...

Thanks for sharing excellent information. Soulblu

Unknown said...

Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

Unknown said...

Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing.

Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

EMMANUEL said...

thank you for your post

Python Training in chennai | Python Classes in Chennai

aishu said...

Really awesome blog!!! I finally found great post here.I really enjoyed reading this article. Thanks for sharing your innovative ideas to our vision. your writing style is simply awesome with useful information. Very informative, Excellent work! I will get back here. . AWS Course in Chennai

Aishwariya said...

This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
Reactjs Training in Chennai |
Best Reactjs Training Institute in Chennai |
Reactjs course in Chennai