SQL Server is a Relational Database management system (RDBMS), its a product of Microsoft. The primary functions of the SQL Server is to store and retrieve data to be used by other applications as like normal database servers.
This section helps you understand SQL Server very quickly.
A data definition or data description language is similar to computer programming language used in defining data structures especially database schemas.
DDL statements create, modify and remove database objects like tables, indexes and users.
DDL statements are ALTER, CREATE & DROP
DML is a computer language includes commands permitting users to manipulate data in a database. This involves INSERTING, RETRIEVING and DELETING data from the existing data.
DML is highly inculcated in SQL databases.
This server contains many types of functions which are inbuilt .They are
Datatype | Description |
---|---|
ASCII | returns the ASCII value for a specific character |
CHAR | returns character based on a ASCII code |
CHARINDEX | returns the position of a substring in a string |
LEN | returns the length of a string |
STR | returns a number as a string |
Datatype | Description |
---|---|
ABS | returns the absolute value of a number |
AVG | returns the average value of an expression |
COS | returns the cosine value of a number |
DEGREES | converts the value of radians to degrees |
SQRT | returns the square root of a number |
Datatype | Description |
---|---|
DAY | returns the day of a month for a specified date |
MONTH | returns the month part for a specified date |
DATEADD | adds date/time interval to date and then returns to date |
DATEDIFF | returns the difference between two dates |
Datatype | Description |
---|---|
CAST | converts value of any type into a specified data type |
CONVERT | converts value of any type into a specified data type |
NULLIF | returns NULL if two expressions are equal |
SYSTEM USER | returns the login name for current user |
operator | description |
---|---|
+ | addition |
- | subtraction |
* | multiplication |
/ | division |
Operator | description |
---|---|
& | Bitwise AND |
^ | Bitwise Exclusive OR |
Operator | Description |
---|---|
= | Equal to |
> | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
Operator | Description |
---|---|
+= | Add equals |
-= | Subtract equals |
*= | Multiply equals |
/= | Divide equals |
%= | Modulo equals |
&= | Bitwise AND equals |
^-= | Bitwise exclusive equals |
Operator | Description |
---|---|
ALL | TRUE if all of the subquery values meet the condition |
AND | TRUE if all the conditions separated by AND is TRUE |
ANY | TRUE if any of the subquery values meet the condition |
BETWEEN | TRUE if the operand is within the range of comparisons |
EXISTS | TRUE if the subquery returns one or more records |
IN | TRUE if the operand is equal to one of a list of expressions |
LIKE | TRUE if the operand matches a pattern |
NOT | Displays a record if the condition(s) is NOT TRUE |
OR | TRUE if any of the conditions separated by OR is TRUE |
SOME | TRUE if any of the subquery values meet the condition |
SQL Server Connection String Formats
posted on 2019-08-27 05:53:53 - SQL Server Tutorials