Thursday , April 18 2019
Home / DataBase / SQL SERVER (page 5)


Sql Server String Functions (ONE BY ONE):-

Sql Server String Functions

Sql Server String Functions  :- 1)ASCII(s) 2)CHAR(n) 3)NCHAR(n) 4) LEN(s) 5) CHARINDEX() 6)CONCAT() 7)LEFT(s,n) 8)RIGHT(s,n) 9) SUBSTRING(s,start,length) 10)LOWER(s) 11)UPPER(s) 12)LTRIM(expression) 13) RTIMM(expression) 14) REPLACE(Expression,Pattern, Replacement_Value) 15) REPLICATE(s,n) 16) REVERSE(s) 17)  STUFF(Eepression, Start, length, Replacement_expression) 18) SPACE(n) 1)ASCII(s):- ASCII(s) function returns ASCII code of the given character expression. [crayon-5cb88da7f381d999815189/] Note:-Here “s” is …

Read More »

Mathematical Functions in Sql Server(One By One):-

Mathematical Functions

Mathematical Functions in Sql Server:- Sql Server Contains different  types of Mathematical Functions:- Abs() Ceiling() Floor() Power() Square() SQRT() Rand() Round() Sign() PI() Log()   1.Abs() :-  Abs() stands for absolute and returns  the absolute (positive) number. [crayon-5cb88da800948344359255/] Note :- Here “n” is a numeric expression. [crayon-5cb88da80094f568308298/] 2.Ceiling() :-  Ceiling() …

Read More »

SQL Server Management Studio Shortcut Keys

Sql server shortcut keys

SQL Server Management Studio Shortcut Keys: Keyboard shortcuts save a lot of time and can improve productivity as well. SQL server Management Studio has several keyboard shortcuts. Here, we will explore the most essential and Important shortcuts which will make our daily programming More easily.   See Also Visual Studio Shortcut …

Read More »

Create Not Null Constraint in sql Server

Create Not Null Constraint in sql Server: Not Null: If it is imposed on a column that column will not allow Null Values into it; this can be imposed on any no of columns. Syntax:- [crayon-5cb88da800fba299977552/] Example:- [crayon-5cb88da800fc1241291892/] Explanation:-  The above Example Explains you the Empid Column Not allowed Null …

Read More »

Create Check Constraint in Sql Server

Create Check Constraint in Sql Server Check Constraint: If we want to check the values present in a column to be according to a specified value we use this constraint. Syntax: [crayon-5cb88da801310781828792/]     Example: [crayon-5cb88da801316798069425/] Explanation: The Above Example Explains you the Employee salary Should be more than 1000 .If …

Read More »

Create Default Constraint in Sql Server

Create Default Constraint in Sql Server Default Constraint:-It is useful to provide default value into a column when user will not provide any value while inserting the data into the table then default value will be arranged. Column Level Definition: In this case the constraint definition is immediately followed after …

Read More »

Create Unique Constraint In Sql Server

Create Unique Constraint In Sql Server Unique Constraint:-  When  we  place UNIQUE constraint on any column ,It will not allow duplicate values but it allows single null value. Unique  Key Constraints can be imposed in two different ways: 1.Column Level Definition 2.Table Level Definition Column Level Definition: In this case …

Read More »


TRANSACTIONS CONTROL LANGUAGE (TCL):  Transaction is nothing but a unit of work. We can control these transactions using the following statements ROLLBACK Statement COMMIT Statement SAVE TRAN [SACTION] 1.ROLLBACK Statement: ROLLBACK statement is used to cancel a particular performed transaction. 2. COMMIT Statement: COMMIT statement makes a transaction permanent. It …

Read More »


DATA CONTROL LANGUAGE(DCL)  In Sql Server DATA CONTROL LANGUAGE: By Using DCL We Can control the data between different user accounts. DCL Commands Includes GRANT Statement       2.REVOKE Statement   1.Grant Statement: By Using Grant Statement we can  grant the permissions (INSERT, SELECT, UPDATE, DELETE) on a specific table to …

Read More »


DATA MANIPULATION LANGUAGE: INSERT Statement SELECT Statement UPDATE Statement DELETE Statement 1.INSERT Statement: By Using INSERT Statement   we can inserting the values into a specific table. 2.SELECT Statement: By Using SELECT Statement   we can retrieving the data from a specific table.  3.UPDATE Statement: By Using UPDATE Statement   we can modifying the data, which …

Read More »
Page 5 of 6
1 3 4 5 6