Tuesday , November 13 2018
Home / Samba (page 2)

Samba

August, 2016

  • 15 August

    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 …

  • 14 August

    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-5be9ffb269b28456670237/]   Table 2: …

  • 5 August

    Special Functions

    sql server special functions

    Special Functions:- below are the Special Functions in sql server. 1.IsNUll():- Used to convert Nulls [crayon-5be9ffb26a114257685427/] if expr1 is Null returns expr2 if expr1 is NotNull returns expr1 only [crayon-5be9ffb26a11b331489169/] 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 …

  • 3 August

    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 …

  • 2 August

    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-5be9ffb26a889327844273/] [crayon-5be9ffb26a890875551519/] 2.convert:- [crayon-5be9ffb26a893358868748/] [crayon-5be9ffb26a896211084449/] [crayon-5be9ffb26a899482261466/] using data functions we can display dates in different formats. [crayon-5be9ffb26a89c034268032/]  

July, 2016

  • 2 July

    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-5be9ffb26ac45602921918/] [crayon-5be9ffb26ac4b258294074/] 10. MONTH(): MONTH() Functions Returns an …

June, 2016

  • 16 June

    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() …

  • 9 June

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

  • 7 June

    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-5be9ffb26c3da822152049/] Note :- Here “n” is a numeric expression. [crayon-5be9ffb26c3e1514015927/] 2.Ceiling() :-  Ceiling() …

April, 2016

  • 22 April

    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-5be9ffb26c9ea220257249/] Example:- [crayon-5be9ffb26c9f1062758372/] Explanation:-  The above Example Explains you the Empid Column Not allowed Null …

  • Page 2 of 4
    1 2 3 4