NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,505 reads
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,505 reads
New Version Sql Server “11? code name “Denali” CPT1 is ready to download here: http://msdn.microsoft.com/en-us/sqlserver/default.aspx Here are experts comment and...
2010-11-10
922 reads
Everyone know how to uninstall sql server very easy : control panel -<Add remove programs ->sql server some times you can...
2010-11-02
553 reads
There are different ways you can communicate to sql server: 1. Shared memory: on the local server 2. Named Pipe:...
2010-10-21
549 reads
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
463 reads
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,768 reads
When you configure the memory and on your system if other applications are also present, in such cases specially for...
2010-08-16
470 reads
It’s been quite some time that I blog, Sorry about that I was busy with my movement from USA to...
2010-08-07
858 reads
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,010 reads
Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing...
2010-06-03
465 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
You paste a slow Redshift query plan into PlanTrace and one of the tuning...
By Steve Jones
As part of my running the SQL Saturday charitable foundation, I get sponsorship money...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers