Monday, 7 November 2016

SQL SERVER APPLICATION NAME FORMULA

SQL SERVER APPLICATION NAME FORMULA


/* HI ALL, TODAY WE ARE LOOKING AT SQL SERVER 2012 DISPLAY THE APPLICATION
NAME OF THIS APP FUNCTION.


IT'S A SIMPLE QUERY.


HERE GOES. */


/* I HAVE ALSO ADDED AN ALIAS FIELD HEADER CALLED APP_NAME AFTER THE FUNCTION NAME


NOTE: YOU HAVE TO USE SQUARE BRACKETS FOR RESERVED NAMES SUCH AS APP_NAME.


THAT IS IT. */


SELECT APP_NAME() AS [APP_NAME];


Figure 4 APP NAME



No comments:

Post a Comment