Heart felt articles

by Rajesh 21. November 2010 22:29

When we go through articles and videos we end up with different feelings (sad, happy,dull,sharp,etc..)

But some articles really makes us think & we feel heavy and this was the recent one for me.

http://www.ted.com/...

 

Tags:

Children in motorcycle

by Rajesh 19. November 2010 13:36

Today I wanted to start the idea of buying a motorcycle and was looking into the details.

Through the course wanted to check what are the requirements/addons for taking Aryan (my 4 yrs) along with me.

One of my search came up with this image and I was dumbstruck.

 

 

Moved my provider

by Rajesh 2. November 2010 17:17

I have hosted my blogs for several years on a hosting provided

by http://www.aruba.it/ 

They have an excellent service  for 45 euro a year is a great bargain.

Now I have moved my blog to Godaddy seeing their flexible features and options,

they are far ahead when I compare the services with aruba.

The main challenge was to keep the old deep links and images working.

I think I found a way to migrate everything using a set of good tools.

Along with the migration, added a new domain www.rajeshvar.com too. Smile

Ping me if you find anything buggy.

Tags:

Cleanse your mobiles

by Rajesh 20. October 2010 01:20

I often thought about cleansing my mobile and never do it..

After reading this news of mobiles dirtier than toilet handles.. http://www.telegraph.co.uk....

I found this product is cool.. Cleaning your phone using ultraviolet..

 

Planning to buy this.

How to search a SQL database for a text?

by Rajesh 27. September 2010 23:36


I had a requirement to run a full text search, without configuring default full text search on sql server and found this stored procedure which was really helpful.

 

hih

The procedure

CREATE PROC SearchAllTables
(
	@SearchStr nvarchar(100)
)
AS
BEGIN

	-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
	-- Purpose: To search all columns of all tables for a given search string
	-- Written by: Narayana Vyas Kondreddi
	-- Site: http://vyaskn.tripod.com
	-- Tested on: SQL Server 7.0 and SQL Server 2000
	-- Date modified: 28th July 2002 22:50 GMT


	CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

	SET NOCOUNT ON

	DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
	SET  @TableName = ''
	SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

	WHILE @TableName IS NOT NULL
	BEGIN
		SET @ColumnName = ''
		SET @TableName = 
		(
			SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
			FROM 	INFORMATION_SCHEMA.TABLES
			WHERE 		TABLE_TYPE = 'BASE TABLE'
				AND	QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
				AND	OBJECTPROPERTY(
						OBJECT_ID(
							QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
							 ), 'IsMSShipped'
						       ) = 0
		)

		WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
		BEGIN
			SET @ColumnName =
			(
				SELECT MIN(QUOTENAME(COLUMN_NAME))
				FROM 	INFORMATION_SCHEMA.COLUMNS
				WHERE 		TABLE_SCHEMA	= PARSENAME(@TableName, 2)
					AND	TABLE_NAME	= PARSENAME(@TableName, 1)
					AND	DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
					AND	QUOTENAME(COLUMN_NAME) > @ColumnName
			)
	
			IF @ColumnName IS NOT NULL
			BEGIN
				INSERT INTO #Results
				EXEC
				(
					'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630) 
					FROM ' + @TableName + ' (NOLOCK) ' +
					' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
				)
			END
		END	
	END

	SELECT ColumnName, ColumnValue FROM #Results
END

 

Source : Original


 

Asha Zurich Chapter

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar