A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
create procedure sp_getviewmetadata @db_name varchar(20), @view_name varchar(20), @owner varchar(20) as declare @text varchar(1024) declare @text_line varchar(1024) declare @lines_count int declare @i int select @text = "", @i = 1 select @lines_count = count(c.text) from syscomments c, sysobjects o, sysusers u where o.id = c.id and o.uid = u.uid and o.name = @view_name and u.name = @owner create table #viewquery ( sqlquery text ) while (@i <= @lines_count) begin select @text_line = c.text from syscomments c, sysobjects o, sysusers u where o.id = c.id and o.uid = u.uid and o.name = @view_name and u.name = @owner and colid = @i if @i = 1 insert into #viewquery select @text_line else update #viewquery set sqlquery = sqlquery + convert(text, @text_line) select @i = @i + 1 end select #viewquery.sqlquery from #viewquery
|sybase license issue||6||561|
|Excel Code not seeing ODBC driver for Sybase||1||1,083|
|compare Sybase and MSSQL server||18||950|
|How would you modify a SQL Update statement to include matching on a field that has the highest value for an int type field?||4||204|