programbr

SQL Operators

SQL Operators

 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 […]

SQL Operators Read More »

SQL Data Types

SQL Data Types

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 Data Types Read More »

Scroll to Top