Re: Help
From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 03/30/04
- Next message: Wayne Snyder: "Re: How to improve performance of the report's display while updating the table?"
- Previous message: randyvol: "recover - how do I tell if it is really happening?"
- In reply to: :\): "Help"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Mar 2004 14:10:15 -0500
if you are looking for anything that has "order by " and a digit why not
take it out of the loop and try
c.text like '%order by [0-9]%'
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
":)" <anonymous@discussions.microsoft.com> wrote in message
news:14fc301c41585$6bb3b6b0$a401280a@phx.gbl...
> I changed it a bit.. can anyone tell me how i can get rid
> of the "number 25" but keep what i am trying to do(cause
> some tables have more columns and some have less than 25):
>
> declare @i varchar(10)
> set @i = '1'
>
> while @i < 25
> begin
> select distinct o.name from syscomments c join
> sysobjects o on o.id = c.id
> where o.type IN ('TR','TF','P','X','V','FN')
> and
> c.text like '%order by ' + @i + '%'
>
> set @i = @i+1
> end
>
>
>
> >-----Original Message-----
> >Can anyone help me,
> >I am writting a script where i get to find out all the
> >store procedure, triggers,... that has the
> command "..from
> >table_name order by 2,1.." for example...
> >
> >Here is what i got as a base idea... hope you understand
> >what i am trying to get at:
> >declare @i int
> >declare @tbnames varchar (150)
> >set @i = 1
> >
> >declare test cursor for
> > select [name] from sysobjects where xtype = 'U'
> >
> >open test
> >fetch next from test into @tbnames
> >
> >if @@fetch_status = 1
> >
> >Begin
> >
> > if @i < 9
> >
> > begin
> > select o.name from syscomments c join sysobjects o
> >on o.id = c.id
> > where o.type IN ('TR','TF','P','X','V','FN')
> > and
> > c.text like '%from ' + @tbnames + 'order by' + @i
> >+ '%'
> >
> > set @i = @i + 1
> > end
> >
> >
> >fetch next from test into @tbnames
> >
> >End
> >
> >close test
> >deallocate test
> >
> >Can anyone give me a hand with this please
> >.
> >
- Next message: Wayne Snyder: "Re: How to improve performance of the report's display while updating the table?"
- Previous message: randyvol: "recover - how do I tell if it is really happening?"
- In reply to: :\): "Help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
