Tag: Microsoft SQL Server

Format Date in SQL Server

It’s very common to show the current date (i.e., month, day, and year) in different formats. […]

Quickie – Concatenate Rows as a String

Today I needed to concatenate a field from multiple rows in SQL Server to get a […]

Problem with Database Restore

Last week, I restored a database from backup and was having the following error when trying […]

Find Database Creation Date | Quickie

To find the database creation dates, you need to insert the following query in SQL Server […]

Order BY Not Working in SQL Server Functions | Quickie

Ever created a function and needed to include the Order By clause. It would result in […]

SQL Server | Reset Identity Column

When you create a table in SQL Server, you would also have an Identity Primary Key. This […]

ASP.Net | Read Values from Javascript

Today I started checking out some videos about Windows CardSpace and ASP.Net for logging in and […]

SQL Server 2005 | Add days, months and years to GetDate()

To get the current date in Sql Server queries and stored procedures, you use the GetDate() […]

SQL Server | Convert Varchar to UniqueIdentifier

There are 2 ways to Convert a string to a UniqueIdentifier (GUID) in SQL Server: SELECT CAST(‘449141d9-86c9-449d-be2c-1f171b4f4567’ as UNIQUEIDENTIFIER) SELECT CONVERT(UNIQUEIDENTIFIER, […]

SQL Server | Remove Special Characters

I needed to remove all the special characters from a field in a particular table in […]