SQL Server System Functions


Aggregate Functions


       1.Avg() 

          Parameters : Expression (Numeric type)
          Return Types: integer,decimal,float or money

       2.Binary_checksum()

         Parameters : Expression (Any type)
         Return Types: numeric

       3.Checksum()

         Parameters : Expression (Any type)
         Return Types : integer

       4.Checksum_agg()

         Parameters :Expression(integer type)
         Return Types : integer

       5.Count()

         Parameters :Expression(Any type)
         Return Types :interger

       6.Count_big()

         Parameters :Expression(Any type)
         Return Types :bigint

      7.Grouping()

        Parameters :Expresssion (Any type)
        Return Types :integer


      8.Grouping_Id()

       Parameters :Expression1(Any type),Expression2(Any type),ExpressionN(Any type)
       Retruns Types :integer

      9.Max()

       Parameters :Expression(Any type)
       Returns Types :Same type of the Expression


     10.Min()

       Parameters :Expression(Any type)
       Return Types:Same type of the Expression

      11.Stdev()

       Parameters :Expression(Numeric type)
       Return Types :float

      12.Stdevp()

        Parameters :Expression(Numeric type)
        Return Types:float

      13.Sum()

        Parameters :Expression(Numeric type)
        Return Types :integer,decimal,money or float

     14.Var()

       Parameters :Expression(Numeric type)
       Return Types:float


     15.Varp()

       Parameters :Expression(Numeric type)
       Return Types :float

Comments

Post a Comment

Popular posts from this blog

Setup and implement simple angular.js program in MVC

Image
Here I'm writing simple steps for how to  setup angular.js in ASP.NET MVC application and implement small program using angular.js. 1. Create a MVC web application using VisualStudio. 2. Add following Angular js references to _layout page(Master page) as per showing below   <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.3.0-rc.2/angular.min.js"></script>    <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.3.0-rc.2/angular-touch.js"></script>     <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.3.0-rc.2/angular-resource.js"></script>    <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.3.0-rc.2/angular-animate.js"></script>     <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.3.0-rc.2/angular-route.js"></script>    <script src="//ajax.googleapis.com/ajax/libs/angularjs/1.3.0-rc.2/angular-mocks.js"></...
Read more

Cross browsers detect print events using javascript

Image
Here I'm explain about detecting before print, after print in cross browsers using Java script. Window beforeprint,afterprint events working in only IE,Firefox browsers, but we can detect these events using  matchMedia with event handler, here I'm explain with small example. Javascript Code: (function () {         var beforePrint = function () {             alert('Functionality to run before printing.');         };         var afterPrint = function () {             alert('Functionality to run after printing');         };         if (window.matchMedia) {             var mediaQueryList = window.matchMedia('print');             mediaQueryList.addListener(function (mql) {                 if (mql.matches) {...
Read more

HTML5 drag and drop

Image
Live Demo : 1 2 3 4 Source code : css : <style>     .dropdiv {         width: 50px;         height: 50px;         padding: 10px;         border: 1px solid #aaaaaa;     }     .spn {     font-size:50px     }    </style> JAVASCRIPT : <script>     function allowDrop(ev) {         ev.preventDefault();     }     function drag(ev) {         ev.dataTransfer.setData("text", ev.target.id);     }     function drop(ev) {         ev.preventDefault();         var data = ev.dataTransfer.getData("text");     ...
Read more