{"id":1825,"date":"2017-04-29T22:31:40","date_gmt":"2017-04-29T15:31:40","guid":{"rendered":"http:\/\/student-activity.binus.ac.id\/himsisfo\/?p=1825"},"modified":"2017-04-29T22:31:40","modified_gmt":"2017-04-29T15:31:40","slug":"syntax-syntax-dalam-microsoft-sql-2012","status":"publish","type":"post","link":"https:\/\/student-activity.binus.ac.id\/himsisfo\/2017\/04\/syntax-syntax-dalam-microsoft-sql-2012\/","title":{"rendered":"SYNTAX-SYNTAX DALAM MICROSOFT SQL 2012"},"content":{"rendered":"

Siapa yang tidak kenal Microsoft SQL 2012? Aplikasi pengolah database ini sering kita gunakan untuk membuat database. Namun, syntax-syntax yang digunakan dalam Microsoft SQL disebut\u00a0 Data Definition Language. Berbeda dengan aplikasi programming lain yang menggunakan Java, C#, C++ dan lain-lain. Berikut beberapa Syntax dalam Microsoft SQL 2012:<\/p>\n

    \n
  1. Create Database<\/strong><\/li>\n<\/ol>\n

    Digunakan untuk membuat Database baru<\/p>\n

    Create database <nama database><\/em><\/p>\n

    Maka, Database baru telah dibuat.<\/p>\n

    Contoh:<\/p>\n

    Create database kampus<\/em><\/p>\n

    \n

      \n
    1. Create Table<\/strong><\/li>\n<\/ol>\n

      Digunakan untuk membuat table baru<\/p>\n

      create table <nama table>(<\/em><\/p>\n

      <column 1> <Tipe Data> <Length> <Statement><\/em><\/p>\n

      <column 2> <Tipe Data> <Length> <Statement><\/em><\/p>\n

      \u2026<\/em><\/p>\n

      )<\/em><\/p>\n

      Maka, Table baru telah dibuat<\/p>\n

      Contoh:<\/p>\n

      Create table Mahasiswa(<\/em><\/p>\n

      StudentID char (5) Not null,<\/em><\/p>\n

      StudentName Varchar (20) Not null,<\/em><\/p>\n

      Student Address varchar (20) Not null<\/em><\/p>\n

      )<\/em><\/p>\n

      \u00a0<\/em><\/p>\n

        \n
      1. Drop Table<\/strong><\/li>\n<\/ol>\n

        Digunakan untuk menghapus table<\/p>\n

        Drop Table <nama table><\/em><\/p>\n

        Contoh:<\/p>\n

        Drop Table Mahasiswa<\/em><\/p>\n

        \u00a0<\/em><\/p>\n

          \n
        1. Create & Drop View<\/strong><\/li>\n<\/ol>\n

          Digunakan untuk membangun beberapa table yang sudah ada, fungsi ini disebut juga \u201cVirtual Tabel\u201d<\/p>\n

            \n
          • Create View<\/strong><\/li>\n<\/ul>\n

            Create View <nama view> <Column 1, column 2><\/em><\/p>\n

            As<\/em><\/p>\n

            Select <Column 1, column 2><\/em><\/p>\n

            From <nama table><\/em><\/p>\n

            Where <Condition><\/em><\/p>\n

            Contoh:<\/p>\n

            Create view ViewDetailAttendance<\/em><\/p>\n

            as<\/em><\/p>\n

            select Name = (StudentName),<\/em><\/p>\n

            AttendanceStatus,<\/em><\/p>\n

            RoomName,<\/em><\/p>\n

            ScheduleDate<\/em><\/p>\n

            from Student s, DetailClassAttendance d, HeaderClassAttendance h, Room r<\/em><\/p>\n

            where s.StudentID = d.StudentID<\/em><\/p>\n

            and d.ClassAttendanceID = h.ClassAttendanceID<\/em><\/p>\n

            and h.RoomID = r.RoomID<\/em><\/p>\n

            and (day(ScheduleDate)>24 or AttendanceStatus = ‘Absent’)<\/em><\/p>\n

            \u00a0<\/em><\/p>\n

              \n
            • Drop View<\/strong><\/li>\n<\/ul>\n

              Drop View <nama view><\/em><\/p>\n

              Contoh:<\/p>\n

              Drop View ViewDetailAttendance<\/em><\/p>\n

              \u00a0<\/em><\/p>\n

                \n
              1. Alter Statement<\/strong><\/li>\n<\/ol>\n

                Adalah sebuah syntax dalam SQL untuk mengubah definisi dalam table SQL<\/p>\n

                Syntax-syntax tersebut adalah:<\/p>\n

                  \n
                • Add new column<\/strong><\/li>\n<\/ul>\n

                  Alter Table <nama table><\/em><\/p>\n

                  Add <nama kolom> <tipe data><\/em><\/p>\n

                  Contoh:<\/p>\n

                  Alter table Mahasiswa<\/em><\/p>\n

                  Add Kota Varchar (20)<\/em><\/p>\n

                  \u00a0<\/em><\/p>\n

                    \n
                  • Change the data type of a column in a table<\/strong><\/li>\n<\/ul>\n

                    Alter Table <nama table><\/em><\/p>\n

                    Alter Column <nama kolom> <tipe data><\/em><\/p>\n

                    Contoh:<\/p>\n

                    Alter Table Mahasiswa<\/em><\/p>\n

                    Alter Column Alamat char (5)<\/em><\/p>\n

                    \u00a0<\/em><\/p>\n

                      \n
                    • Drop Column<\/strong><\/li>\n<\/ul>\n

                      Alter Table <nama table><\/em><\/p>\n

                      Drop Column <nama kolom><\/em><\/p>\n

                      Contoh:<\/p>\n

                      Alter Table Mahasiswa<\/em><\/p>\n

                      Drop Column City<\/em><\/p>\n

                      \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Itulah beberapa contoh Data Definition Language dalam Microsoft SQL 2012. Semoga Informasi ini bermanfaat.<\/p>\n

                      Sumber Penulisan\/Daftar Pustaka :<\/strong> Diktat Basic Database 2011 Software Laboratory Center<\/p>\n","protected":false},"excerpt":{"rendered":"

                      Siapa yang tidak kenal Microsoft SQL 2012? Aplikasi pengolah database ini sering kita gunakan untuk membuat database. Namun, syntax-syntax yang digunakan dalam Microsoft SQL disebut\u00a0 Data Definition Language. Berbeda dengan aplikasi programming lain yang menggunakan Java, C#, C++ dan lain-lain. Berikut beberapa Syntax dalam Microsoft SQL 2012: Create Database Digunakan untuk membuat Database baru Create […]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1825","post","type-post","status-publish","format-standard","hentry","category-article"],"_links":{"self":[{"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/posts\/1825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/comments?post=1825"}],"version-history":[{"count":1,"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/posts\/1825\/revisions"}],"predecessor-version":[{"id":1826,"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/posts\/1825\/revisions\/1826"}],"wp:attachment":[{"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/media?parent=1825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/categories?post=1825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/student-activity.binus.ac.id\/himsisfo\/wp-json\/wp\/v2\/tags?post=1825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}