Showing posts with label Information. Show all posts
Showing posts with label Information. Show all posts

Monday, 14 November 2016

SQL SERVER PUBLISHING SERVER NAME

SQL SERVER PUBLISHINGSERVERNAME

-- EXAMPLE

SELECT PUBLISHINGSERVERNAME() AS [DISPLAY CONNECTION NAME];

SQL SERVER PROGRAM NAME

SQL SERVER PROGRAM NAME

-- EXAMPLE

SELECT PROGRAM_NAME() AS [DISPLAY THIS PROGRAM'S NAME];

SQL SERVER PLATFORM FORMULA

SQL SERVER PLATFORM FORMULA

-- EXAMPLE

SELECT PLATFORM() AS [DISPLAY MY PLATFORM NUMBER];

SQL SERVER NT_CLIENT FORMULA

SQL SERVER NT_CLIENT FORMULA

-- EXAMPLE

SELECT NT_CLIENT() AS [DISPLAY MY SQL SERVER CONNECTION PATH];

SQL SERVER ORIGINAL LOGIN FORMULA

-- EXAMPLE

SELECT ORIGINAL_LOGIN() AS [DISPLAY MY CONNECTION AND USER NAME];

SQL SERVER NEWID FORMULA

SQL SERVER NEWID FORMULA

-- EXAMPLE

SELECT NEWID() AS [DISPLAY NEW GLOBAL UNIQUE IDENTIFIER];

SQL SERVER MIN_ACTIVE_ROWVERSION FORMULA

SQL SERVER MIN_ACTIVE_ROWVERSION FORMULA

-- EXAMPLE

SELECT DISTINCT MIN_ACTIVE_ROWVERSION() AS [MINIMUM OR LOWEST ACTIVE ROW VERSION];

SQL SERVER INFORMATION SCHEMA METADATA FOR TABLES AND COLUMNS

SQL SERVER INFORMATION SCHEMA METADATA FOR TABLES AND COLUMNS

-- THEORY

-- SELECT * FROM INFORMATION_SCHEMA.[TYPE]

-- EXAMPLE

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS;

-- RESULT A REPORT ON TABLES AND VIEWS WITH THEIR DATA TYPES AND STRUCTURE

-- SQL SERVER IS NULL REPLACEMENT VALUE

-- THEORY

-- SELECT [NULL VALUE] AS [ALIAS NAME], ISNULL(NULL,'REPLACEMENT TEXT') AS [ALIAS NAME];

-- EXAMPLE

SELECT NULL AS [NULL], ISNULL(NULL,'THIS IS EMPTY') AS [REPLACEMENT VALUE FOR NULL];

SQL SERVER HOST ID

SQL SERVER HOST ID

-- THEORY

-- SELECT HOST_ID() AS [AliasName];

-- EXAMPLE

SELECT HOST_ID() AS [Host_ID];

-- The result returns an integer value

SQL SERVER HOST NAME RETURNS YOUR CONNECTION NAME

-- THEORY:

-- SELECT HOST_NAME() AS [Alias_Name]

-- EXAMPLE:

SELECT HOST_NAME() AS [Host_Name];

-- RESULT: RETURNS YOUR CONNECTION NAME

SQL SERVER GET CHECK SUM GETCHECKSUM FORMULA

SQL SERVER GET CHECK SUM GETCHECKSUM FORMULA

-- THEORY

-- SELECT Column1, GETCHECKSUM(Column1) AS [Alias_Name]
-- FROM AdventureWorksDW2012.DBO.DimAccount AS ACC;

-- EXAMPLE

SELECT ACC.AccountKey, GETCHECKSUM(ACC.AccountKey) AS [GETCHECKSUM]
FROM AdventureWorksDW2012.DBO.DimAccount AS ACC;

SQL SERVER FILE NAME FORMULA

SQL SERVER FILE NAME FORMULA

/* SQL SERVER FILE NAME FORMULA */

-- HI VIEWERS

-- TODAY WE WILL LOOK AT THE SQL FILE NAME FUNCTION

-- THEORY:

-- SELECT FILE_NAME(ENTER FILE NAME ID NUMBER HERE) AS [ALIAS NAME];

-- EXAMPLE:

SELECT FILE_NAME(2) AS [FILE_NAME];

-- HIGHLIGHT IT AND CLICK EXECUTE OR (F5)

-- YOU CAN GIVE THE COLUMN AN ALIAS OR COLUMN NAME BY USING AS BEFORE THE NAME

-- THE FILE NAME FOR ID 2 AS SEEN BELOW IS

-- AdventureWorksDW2012_Log

-- THAT IS IT

SQL SERVER FILE IDEX FORMULA

SQL SERVER FILE IDEX FORMULA

/* SQL SERVER FILE IDEX FORMULA FOR AdventureWorksDW2012_Log */

-- HI VIEWERS

-- TODAY WE WILL LOOK AT THE FILE IDEX FORMULA

-- THE FILE IDEX FORMULA RETRIEVES THE FILE IDEX VALUE

-- FROM A FILE NAME

-- WE BEGIN BY ENTERING THE KEYWORD SELECT

-- FOLLOWED BY THE FILE IDEX FORMULA

-- ENCLOSED WITHIN IT'S BRACKETS

-- WILL BE THE FILE NAME IN SINGLE QUOTES

-- LIKE SO ...

SELECT FILE_IDEX('AdventureWorksDW2012_Log') AS [FILE IDEX];

-- NOTICE THE VALUE OF 2

-- NOTICE THE COLUMN NAME GIVEN AS AN ALIAS OF [FILE IDEX]

-- THAT IS IT

SQL SERVER FILE ID FORMULA

SQL SERVER FILE ID FORMULA

/* SQL SERVER FILE ID FORMULA FOR AdventureWorksDW2012_Log */

-- HI VIEWERS

-- Today, we will look at displaying the file ID for a log file

-- First we start of with the keyword SELECT

-- Then we enter the formula FILE_ID

-- Within the file ID formula we enter the file name in single quotes ''

-- THEORY:

-- SELECT FILE_ID(FILE NAME) AS [ALIAS NAME]

--EXAMPLE:

SELECT FILE_ID('AdventureWorksDW2012_Log') AS [FILE ID];

-- THE CLICK RUN OR (F5) OR EXECUTE

-- THAT IS IT

SQL FILE GROUP NAMES AND IDs HOW TO DISPLAY THEM

SQL FILE GROUP NAMES AND IDs HOW TO DISPLAY THEM

-- THEORY: SELECT FILEGROUP_NAME(ENTER ID AS AN INTEGER OR NUMBER)

-- THEORY: SELECT FILEGROUP_ID('ENTER NAME AS A TEXT VALUE')

SELECT FILEGROUP_NAME(1);

SELECT FILEGROUP_ID('PRIMARY');

SQL SERVER BRICK ID FORMULA

SQL SERVER BRICK ID FORMULA

--hi all, this is a quick one on how to run a function for a brick ID

--here goes

select BRICK_ID();

--that is it.

--the brick ID is the ID for the segment you are currently in.

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