Blog Detail
Sql Server 2005 Tips and Tricks
http://www.sqlservercurry.com
Get some unique tips tricks and articles on SQL Server 2005. The blogs also cover Sql Server Reporting Services along with SQL Server Administration
- Added on: Mar 10th, 2008
- Country: United States
- Language: English
- Author: loveblog
- Listed in: Programming
- Tags: tips and tricks sql server 2005 ssrs sql server administration t-sql programming
Recent Posts
Validate Email Addresses in SQL Server
I will be honest here – doing email address validation in SQL Server is one of the most challenging tasks a T-SQL programmer faces.Stefan Plattner sometime back on the forums shared a query to validate Email Address. I have been using this query in...
Find Number of Weeks in a Month using SQL Server
I have been asked this question plenty of times – How do I calculate the number of weeks in a month. The answer to this query depends on how do you define a week. For simplicity purposes, I will take a week from Sunday to Saturday as depicted in th...
Getting started with Report Builder 3.0 – Report Parts
Report Builder 3.0 supports SQL Server 2008 R2 Reporting Services and is a separate MSI file for download - Report Builder 3.0 downloadOne of the new features of Report Builder 3.0 is to create, publish and reuse the report parts. Report parts are th...
Exploring New Features of SQL Server 2008 R2 with Excel 2010
SQL Server 2008 R2 November CTP is released and can be downloaded from here .There is a lot of new functionality available with Business Intelligence with SQL Server 2008 R2. In this article, we will use Excel 2010 as a client for SQL Server Analysis...
Update a Column with Random Numbers in SQL Server
In this blog post, I will show you how to update a database column with Random NumbersLet’s create a sample tableDECLARE @TT table(ID smallint,StudentID smallint,DayAlloted smallint)-- Create Sample DataINSERT INTO @TT VALUES ( 101, 1, 0);INSERT I...
Convert Month Number to Month Name in SQL Server
One of my blog readers mailed me asking a simple way to convert a month number to month name. Here’s the simplest way in my opinion:DECLARE @Mth smallintSET @Mth = 11SELECT DateName(mm,DATEADD(mm,@Mth,-1)) as [MonthName]OUTPUT Similarly if you want...
