|
|
-
8
Liked
| 7
Learned
| 1
Comments
|
|
It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for a w...
|
|
-
13
Liked
| 13
Learned
| 16
Comments
|
|
Hi,
Just now i Wrote one query to remove special characters from a string..
Hope this is useful.
DECLARE @I VARCHAR(100)
SELECT @I ='abhi *s d ^.l'
WHILE PATINDEX('%[^A-Za-z0-9 ]%' , @I ) <> 0
BEGIN
SELECT @I= STUFF(@I,PATIN...
|
|
-
6
Liked
| 6
Learned
| 2
Comments
|
|
It is not possible to create the VIEW in another database directly - unlike CREATE TABLE, CREATE VIEW statement doesn't have a "database_name" - part in its syntax. But you can do it by calling sp\_executesql stored procedure:
DECLARE @s nvarchar(1000...
|
|
-
|
|
My friend told me that in an interview he was asked to write a code that sums the digits of the number. He asked me if there is a way of doing it without using a WHILE loop. Here are two methods
Method 1 : Dynamic SQLdeclare @i int, @sql varchar(8000)
s...
|
|
-
|
|
I have already posted blog posts regarding the proper usage of the alias name
http://beyondrelational.com/blogs/madhivanan/archive/2007/11/14/should-alias-names-be-preceded-by-as.aspx http://beyondrelational.com/blogs/madhivanan/archive/2008/09/09/should-alias-names-be-preceded-by-as-part-2.aspx T......
|
|
-
|
|
One of my readers noticed that I had used something resembling excel slicers in my previous post and asked me more on how to implement it in SSRS. For people following the blogosphere, they must already be familiar with this idea as it was introduced al...
|
|
-
|
|
Introduces basics of handling HTTP sessions for maintaining inter-request state on server. Readers will be familiarized with Session API in servlet specification....
|
|
-
|
|
Servlet specification defines concept of filters, which are used to perform pre- and post- processing of requests. This chapter outlines the basics of filter creation, configuration and deployment....
|
|
-
|
|
What would you do if you wanted to check whether a particular query/batch you wrote is free from any errors without using Intelli-sense and without executing or compiling the statement? A T-SQL solution within Microsoft SQL Server to this challenge is to use the SET option PARSEONLY to ON....
|
|
-
|
|
This is part 9 of the series of article on SQL Server Reporting Services. This article explains how to design a Matrix type report with the inbuilt styles available....
|
|