SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
Saturday, January 15, 2011
When to use STUFF instead of REPLACE – SQL Server
›
The STUFF function in SQL Server ‘inserts’ a string into another string. It deletes a specified length of characters in the first string a...
Friday, January 14, 2011
Repairing Error 5235 when the DBCC command fails in MS SQL Server 2008 database
›
In MS SQL Server, the DBCC command is used to perform checks on the databases and repair the errors, if any. Also, there are several repair ...
2 comments:
Thursday, January 13, 2011
What to do when the Error 8910 arises in an MS SQL Server 2000 database
›
An extent in the SQL Server databases is a collection of eight consecutive pages, whose details are stored in an IAM (Index Allocation Map) ...
2 comments:
Convert VarChar to Currency in SQL Server
›
To convert a varchar to currency, the recommended practice is to do the formatting in the front end. However if that option is not available...
Wednesday, January 12, 2011
Check if Database Exists In SQL Server – Different ways
›
A very frequently asked question is how to to check if a Database exists in SQL Server. Here are some different ways. The following code wil...
‹
›
Home
View web version