1)Data Definition Language [D.D.L]
2)Data Manipulation Language [D.M.L]
3)Transaction Control Language [T.C.L]
Types of SQL
This is a 4th generated intermediate language between user and Sql Server.Whenever user wants to interact with Sql Server, he has to interact with Sql Server through SQL. It includes the following Sub Languages:
1)Data Definition Language [D.D.L]
2)Data Manipulation Language [D.M.L]
3)Transaction Control Language [T.C.L]
1)Data Definition Language [D.D.L]
2)Data Manipulation Language [D.M.L]
3)Transaction Control Language [T.C.L]
Data Types in SQL Server
Data type means the type of data which users provided to specific column in Sql Server 2 types of data types available which includes
A)System Defined Data Types
B)User Defined Data Types
A)System Defined Data Types: Sql Server already some data types called System Defined data types or Predefined Data types or Built-in Data types.System Defined Data Types again categorized into 4 types
1)Numeric Data Types
2)String Data Types
3)Date Time Data Types
4) Miscellaneous Data Types
A)Char :Alphanumeric characters (Char) allowed
B) Varchar:Alphanumeric characters (Char) allowed
c)Number:38 bits
d)Date: 7 bytes
Maximum Length of Char is 2000 charaters.
Maximum Length of Varchar is 4000 charaters.
Maximum Length of RAW is 2000 bytes.
Maximum Length of Long is 4GB.
Maximum Length of Long RAW is 4GB
RAW and Long RAW are used for binary data.
Long for comments.
B)User Defined Data Types:SQL Server enables users to create their own databases.Those are called User Defined Databases.
A)System Defined Data Types
B)User Defined Data Types
A)System Defined Data Types: Sql Server already some data types called System Defined data types or Predefined Data types or Built-in Data types.System Defined Data Types again categorized into 4 types
1)Numeric Data Types
2)String Data Types
3)Date Time Data Types
4) Miscellaneous Data Types
A)Char :Alphanumeric characters (Char) allowed
B) Varchar:Alphanumeric characters (Char) allowed
c)Number:38 bits
d)Date: 7 bytes
Maximum Length of Char is 2000 charaters.
Maximum Length of Varchar is 4000 charaters.
Maximum Length of RAW is 2000 bytes.
Maximum Length of Long is 4GB.
Maximum Length of Long RAW is 4GB
RAW and Long RAW are used for binary data.
Long for comments.
B)User Defined Data Types:SQL Server enables users to create their own databases.Those are called User Defined Databases.
SQL Server
Introduction:
MS SQL SERVER is a database management sysem developed and marketed by Microsoft.The SQL SERVER database system was originally developed and implemented by Sybase Inc.Microsoft licensed this DBMS in 1988 for OS/2 operating system and begin implementing it for Windows operating system in the early 1990s.At almost the same time,the further development of SQL SERVER for OS/2 was canceled.In April 1994,Microsoft ended their cooperative agreement with SybaseInc.
MY SQL SERVER runs exclusively under Microsoft operating systems windows 2000,2003 Server and XP.
SQL SERVER was,from the beginning,desinged as client/server DBMS. The Client/Server architecture has been developed to manage a large number of different computers,which are connected using a network. The functionality of SQL Server is divided between clients and server.A client provides one or more different requests to Server. The Server processes this request and sends the result back to the client.
Uses of SQL:
A)SQL is used for all RDBMS Language.
B)It is normal English Language.
c) It is easy to understand.
MS SQL SERVER is a database management sysem developed and marketed by Microsoft.The SQL SERVER database system was originally developed and implemented by Sybase Inc.Microsoft licensed this DBMS in 1988 for OS/2 operating system and begin implementing it for Windows operating system in the early 1990s.At almost the same time,the further development of SQL SERVER for OS/2 was canceled.In April 1994,Microsoft ended their cooperative agreement with SybaseInc.
MY SQL SERVER runs exclusively under Microsoft operating systems windows 2000,2003 Server and XP.
SQL SERVER was,from the beginning,desinged as client/server DBMS. The Client/Server architecture has been developed to manage a large number of different computers,which are connected using a network. The functionality of SQL Server is divided between clients and server.A client provides one or more different requests to Server. The Server processes this request and sends the result back to the client.
Uses of SQL:
A)SQL is used for all RDBMS Language.
B)It is normal English Language.
c) It is easy to understand.
Subscribe to:
Posts (Atom)