String Search

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sean Smith » String Search

String Search

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Smith-776614

Posted Saturday, April 07, 2012 11:48 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Comments posted to this topic are about the item String Search

Post #1279857

Eric Hu²º¹²

Posted Monday, April 09, 2012 6:56 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 09, 2012 7:26 PM
Points: 12, Visits: 19

very very good.

--The confidence is a premise, the courage is a motive, the perseverance is assurance!
http://www.cnblogs.com/huyong/

Post #1280546

Sean Smith-776614

Posted Monday, April 09, 2012 7:25 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Thank you. I hope you find it useful. :)

Post #1280554

Eric Hu²º¹²

Posted Monday, April 09, 2012 7:27 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 09, 2012 7:26 PM
Points: 12, Visits: 19

no problem.

--The confidence is a premise, the courage is a motive, the perseverance is assurance!
http://www.cnblogs.com/huyong/

Post #1280555

dost.kumar2

Posted Tuesday, April 17, 2012 7:35 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 3:50 AM
Points: 10, Visits: 34

Hello any one can help me on. i want to search particular one table.

Post #1284917

Sean Smith-776614

Posted Tuesday, April 17, 2012 10:12 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

You can modify the code temporarily by adding at line 232:

AND O.name = 'MY_TABLE_NAME'

So something like this:

FROM
'+@v_Database_Name+N'.[sys].[schemas] S
INNER JOIN '+@v_Database_Name+N'.[sys].[objects] O ON O.[schema_id] = S.[schema_id]
AND O.[type] IN ('+(CASE
WHEN @v_Object_Types IS NOT NULL THEN @v_Object_Types
ELSE N'''U'', ''V'''
END)+N')
AND O.name = ''MY_TABLE_NAME''
INNER JOIN '+@v_Database_Name+N'.[sys].[columns] C ON C.[object_id] = O.[object_id]

Post #1285079

dost.kumar2

Posted Wednesday, April 18, 2012 4:40 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 3:50 AM
Points: 10, Visits: 34

Thanks for help me..

my table name contain schema name like 'abc.tablename'

when i add table name in my procedure it execute successfully after that run that procedure it's give me error
Invalid column name 'abc.tablename'.
please help me on..
can u send me Change procedure..
-----------

Post #1285533

Sean Smith-776614

Posted Wednesday, April 18, 2012 5:34 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

If you need to include the schema, then something like this should do the trick:

FROM
'+@v_Database_Name+N'.[sys].[schemas] S
INNER JOIN '+@v_Database_Name+N'.[sys].[objects] O ON O.[schema_id] = S.[schema_id]
AND O.[type] IN ('+(CASE
WHEN @v_Object_Types IS NOT NULL THEN @v_Object_Types
ELSE N'''U'', ''V'''
END)+N')
AND O.name = ''MY_TABLE_NAME''
AND S.name = ''MY_SCHEMA_NAME''
INNER JOIN '+@v_Database_Name+N'.[sys].[columns] C ON C.[object_id] = O.[object_id]

Post #1285554

Leon . Orlov .

Posted Monday, July 02, 2012 1:17 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 11:47 AM
Points: 30, Visits: 234

nice little proc. thanks for sharing.

Post #1323991

Sean Smith-776614

Posted Monday, July 02, 2012 4:52 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

My pleasure. Hope you find it handy.

Post #1324074

« Prev Topic | Next Topic »

Permissions