SQL

 Arithmetic Operators Comparison Operators Logical Operators SQL Arithmetic Operators Addition +, add two value Subtraction -, Subtracts right hand operand from left hand operand. Multiplication *, Multiply two value Division /, Divides left hand operand by right hand operand Modulus % , Divides left hand operand by right hand operand and returns the remainder SQL […]

String Data Types Integer Data Types Date and Time Data Types String Data Types in SQL char(n) used to store string of fixed length (max 3000 varchar(n) used to store string of variable length varchar(max) nchar nvarchar text used to store string up to 2GB size ntext binary(n) varbinary image used to store binary string

SQL keywords are not case-sensitive which means SELECT is the same as select. Database and Table names may be case-sensitive, that depends on the operating system. This means database and table names are case-sensitive on Linux/Unix operating systems and case-insensitive on Windows operating systems. Comments in SQL Comments are ignored by database engine. We write

SQL (Structured Query Language) is a standard query language for storing, managing and retrieving data in relational database management system. What is Relational Database Management System A relational Database Management System (RDBMS) is a database management system that is based on the relational model and used to interact with a relational database. RDBMS is based

SQL (Structured Query Language) is a standard query language for storing, managing and retrieving data in relational database management system. SQL is not a database system, it is a query language. It is pronounced as S-Q-L or sometimes as See-Quell. Applications of SQL SQL allows users to access and manipulate databases. SQL allows users to