Hari Sharma

  • Interests: Solving Analytical Puzzles, Making Friends, Movies

Technical Article

Function returns String in Proper Case [CamelCase]

This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'

4.75 (8)

You rated this post out of 5. Change rating

2007-05-09 (first published: )

14,841 reads

Technical Article

Function to calculate Month End Date

This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.Example:Input: '2-20-2004'      Output: '2-29-2004'Input: '2-15-2004'      Output: '2-29-2004'Input: '3-20-2004'      Output: '3-31-2004'Input: '3-30-2004'      Output: '3-31-2004'

3.2 (5)

You rated this post out of 5. Change rating

2007-05-08 (first published: )

1,313 reads

Blogs

Microsoft Announcement: Microsoft Fabric

By

Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store

By

Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders

By

A customer asked about how they could organize their migration scripts in different ways...

Read the latest Blogs

Forums

Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...

SSIS DB

By sqlguru

I was thinking to add SSIS db to Always on AG group. So during...

Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?

By Rich Mechaber

I'm trying to create an SSIS package that will query a master control table...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers