Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions


SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

MS-SQL Scalar functions

SQL Server scalar function takes one or more parameters and returns a single value.

• Upper() - Converts a field to upper case
• Lower() - Converts a field to lower case
• LEN() - Returns the length of a text field
• ROUND() - Rounds a numeric field to the number of decimals specified
Select upper(column_name) from table_name;
Select lower(column_name) from table_name;
Select substring(column_name,start,length) as some_name from table_name;
Select len(column_name) from table_name;
Select productname, round(price,0) as roundedprice from products;