Post Profile






How to format repeating values in SQL result set

A little tip how to format repeating values in SQL output using LAG function
read more

share

Related Posts


Localized Datetime formatting using select query

Programming / Windows Development : CodeProject

IntroductionWhen and how to use sql formatting functions to format datetime values when it is being used by the application that is target to be run

Introduction to SQL Server’s Built-In Logical Functions

Programming / Windows Development : CodeProject

Logical functions provide a way to use logical conditions to display one of several values.  You can use logical functions to test a field’s value such as gender (M or F) and display another value(‘Male’ or ‘Female’) as a result. In...

Using one Isnull() function to remove all null values from all columns a table in SQL Server

Programming / Windows Development : CodeProject

Write a sql query in which we use only one IsNull() function and it will remove all Null values(if any) from entire result set(from all rows)

Executing a web service in a CLR based Table Valued Function and representing its IEnumerable type output a table in SQL Server.

Programming / Windows Development : CodeProject

Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.

SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.

Programming / Windows Development : CodeProject

CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.

Comments


Copyright © 2016 Regator, LLC