Object Search

This Simple script will help to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2016-09-26 (first published: 2016-08-25)

487 reads

Object Search for Sql Server 2005

This script will search databases, tables, columns, stored procedures for text.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2009-01-05 (first published: 2008-12-21)

1,307 reads

The first version of my accounting assistant could not find a single purchase of...

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

I’m really excited about some growth in Flyway support. I’ve been asking about this...

Comments posted to this topic are about the item Pay for Performance, which is...

Comments posted to this topic are about the item Too Many Choices

Comments posted to this topic are about the item Table Partitioning in SQL Server:...

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;