RTRIM() function in SQL Server
RTRIM():-This function is used to get the string after the removal of all trailing blanks.
Syntax:-
RTRIM ( character_expression )
For example:-
Select RTRIM('Vivek Johari ...
2014-08-13
920 reads
T-SQL Tuesday #57: SQL Family and Community
Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that...
2014-08-13
630 reads
Building a Virtual Machine within Azure (IaSS) – Improvements !
Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows...
2014-08-18 (first published: 2014-08-12)
7,418 reads
MS14-044–Security Alert for SQL Server
I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL...
2014-08-12
769 reads
Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
648 reads
T-SQL Tuesday #57 – SQL Family and Community
Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday. TSQL Tuesday is a recurring blog party that...
2014-08-12
10 reads
T-SQL Tuesday #57 – SQL Family and Community
Look at that, it is once again that time of the month that has come to be known as TSQL...
2014-08-12
754 reads
T-SQL Tuesday #57 – SQL Family and Community
Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...
2014-08-12
310 reads
Snippet Alert: Useful dates (eom, bom, etc)
Common date values you may need to reference that you may not want to write from scratch each time.
Hope...
2014-08-12
1,060 reads
Generate Random Date With Starting Point
If you want to create sample random samples when dealing with date calculations to test your results, you can easily...
2014-08-12
536 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers