Category "sql-server-2008-r2"

Select item that is different in each of group by a column

I have this sample table +--------+-------------+ | DBName | Description | +--------+-------------+ | A | Car | | A | Boat | | B

SQL Server "." Alias Not Working

I've added an alias of "." which should point to my local (named) instance, ".\SQL2008". But when I try to connect to ".", it times out. Am I missing something

which is the best way to implement blocking queries or SP's in sql server 2008 r2

I am using SQL Server 2008 R2, and I have to implement the process like if there is any blocking on the production server it will immediately insert into the bl

Run xp_create_subdir without admin privilidges

The Point: I want to be able to create a directory on the filesystem through a non-sysadmin SQL user. I'm creating a web front-end for a deployment script whi

Conversion failed when converting date from character string

I am trying to rearrange Invoice date field of YYYMMDD into short date format DD/MM/YYYY or DD-MM-YYYY UK/British format in a SELECT statement. Performing on