Wednesday , September 19 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-5ba2111118e61221256619/]   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-5ba21111194e0244552418/] if expr1 is Null returns expr2 if expr1 is NotNull returns expr1 only [crayon-5ba21111194e7425741837/] 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-5ba211111a319992193075/] [crayon-5ba211111a320986964485/] 2.convert:- [crayon-5ba211111a324106411879/] [crayon-5ba211111a326199458879/] [crayon-5ba211111a329524779960/] using data functions we can display dates in different formats. [crayon-5ba211111a32c065567580/]  

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-5ba211111a8dc003375882/] [crayon-5ba211111a8e5984851115/] 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-5ba211111ba07491335127/] 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-5ba211111c84f989397630/] Note :- Here “n” is a numeric expression. [crayon-5ba211111c857848029969/] 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-5ba211111cf60017169999/] Example:- [crayon-5ba211111cf68477986001/] Explanation:-  The above Example Explains you the Empid Column Not allowed Null …

  • Page 2 of 4
    1 2 3 4