Thursday , December 14 2017
Home / DataBase / SQL SERVER (page 4)

SQL SERVER

Every Sql Server Developer Should know this Tips

Studyclues_shouldknow

Every SQL Server Developer Should Know this tips 1.Query Execution Order in Sql Query:- 1.From clause 2.Where clause 3.Group by clause 4.Having clause 5.Select clause 6.Order by clause 2. Find  Number of Tables In a Single DataBase   [crayon-5a3248a04f2e6370758438/] 3.Find All Number of Columns In a DataBase [crayon-5a3248a04f2f6451493079/] 4.Find Number of …

Read More »

Multirow Functions:-

Studyclues_MultiRow

Multirow Function:- These functions process group of Rows and Return one value. This functions are also called group functions or aggregate functions. 1.Max():- Returns Maximum value [crayon-5a3248a050265301106468/] [crayon-5a3248a05026e468414811/] Maximum salary of managers? select Max(sal)from emp where Job=’MANAGER’ 2.Min():- Returns Minimum value [crayon-5a3248a050273951808155/] [crayon-5a3248a050278865685483/] 3.Sum():- Returns total [crayon-5a3248a05027c021228295/] 4.Avg():- Returns average …

Read More »

View Classification

Studyclues_Viewes

Views:-  View Definition:- A View is nothing but an image table or virtual table, which is created for a base table. A view can be created by taking all values from the base table or by taking only selected values from base table. There are two types views available in …

Read More »

JOINS

Studyclues JOINS

JOINS: Joins in SQL Server explained bellow (one by one):- These are used for retrieving the data from one or more tables at a time.Joins can be used in any of the following ways. 1.Equi-joins 2.Non-equi-joins 3.Self join 4.Cross join 5.outer join Sample Tables: Table 1:EMPLOYEE [crayon-5a3248a050e7b156444431/]   Table 2: …

Read More »

Special Functions

sql server special functions

Special Functions:- below are the Special Functions in sql server. 1.IsNUll():- Used to convert Nulls [crayon-5a3248a051720780153050/] if expr1 is Null returns expr2 if expr1 is NotNull returns expr1 only [crayon-5a3248a05172a470935367/] Sal+comm as total sal from enp 1.select empno,ename,sal,comm,sal+comm as totalsal from enp. In the above case if something sal+Null= Null 2.select …

Read More »

Rollup and Cube in sql server :-

roll up

Rollup and cube:- Both rollup and cube extends functionality groupby clause Rollup: The ROLLUP operator is useful in generating reports that contain subtotals and totals. The ROLLUP operator generates a result set that is similar to the result sets generated by the CUBE operator. ROLLUP in SQL Server is used to …

Read More »

Conversion Functions in sql server

Converion Functions

Conversion Functions in sql server:- Used to convert from one data type to another data type 1.cast 2.convert 1. cast:- [crayon-5a3248a05210e586994955/] [crayon-5a3248a052117651610877/] 2.convert:- [crayon-5a3248a05211c223434431/] [crayon-5a3248a052120621039656/] [crayon-5a3248a052124150976332/] using data functions we can display dates in different formats. [crayon-5a3248a052129239965579/]  

Read More »

Sql Server Date Functions Part-2

Sql Server Date Functions

Sql Server Date Functions: In Previous Article we have seen some sql  server date functions now i am continues remaining date function in this article 9.DAY(): DAY() functions returns an integer that represents the day of the month of the specified year date. [crayon-5a3248a052606181028032/] [crayon-5a3248a05260e047773878/] 10. MONTH(): MONTH() Functions Returns an …

Read More »

Sql Server Date Functions(One by One):

Sql Server Date Functions

Sql Server Date functions: SQL Server date functions are scalar functions that perform an operation on a date and time input value and returns either a string, numeric, or date and time value.  Some date and time functions are categorized as deterministic functions while others are non-deterministic. 1.GETDATE() 2.GETUTCDATE() 3.SYSDATETIME() …

Read More »

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-5a3248a05365f111369909/] Note:-Here “s” is …

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