Saturday , July 21 2018
Home / Samba (page 2)


August, 2016

  • 15 August

    View Classification


    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


    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-5b527d04327e1335872808/]   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-5b527d0432dbe057512020/] if expr1 is Null returns expr2 if expr1 is NotNull returns expr1 only [crayon-5b527d0432dc4693018650/] Sal+comm as total sal from enp empno,ename,sal,comm,sal+comm as totalsal from enp. In the above case if something sal+Null= Null …

  • 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-5b527d04334f4051272065/] [crayon-5b527d04334fa725942951/] 2.convert:- [crayon-5b527d04334fe663539116/] [crayon-5b527d0433500130474720/] [crayon-5b527d0433503876075429/] using data functions we can display dates in different formats. [crayon-5b527d0433506487851551/]  

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-5b527d0433886648964191/] [crayon-5b527d043388c140508050/] 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-5b527d04343c5651428738/] 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-5b527d043502e495332932/] Note :- Here “n” is a numeric expression. [crayon-5b527d0435037875753317/] 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-5b527d0435621949923597/] Example:- [crayon-5b527d0435628314057913/] Explanation:-  The above Example Explains you the Empid Column Not allowed Null …

  • Page 2 of 4
    1 2 3 4