Any Static Code Analysis Tools for Stored Procedures?

database tsql stored-procedures plsql static-analysis
suyasha picture suyasha · Feb 10, 2009 · Viewed 14.8k times · Source

Are there any static code analysis tools for stored procedures written particularly in PL/SQL and T-SQL?

Answer

MichaelGG picture MichaelGG · Feb 10, 2009

For T-SQL, Microsoft has the database edition of VS Team Suite (although, I believe its now in the dev SKU). This link talks about writing your own static code analysis rule for T-SQL: http://blogs.msdn.com/gertd/archive/2009/01/01/creating-t-sql-static-code-analysis-rules.aspx

Related questions

Stored procedure with named parameter and calculation

I'm calling a stored procedure with named parameter. exec MySP @name = 'binesh', @amount = @amt, @date = @date It's working fine for me. But when I'm trying exec MySP2 @name = 'binesh', @amount = -@amt, @date = @date or exec MySP3 @name = 'binesh', @amount = @…

Read More
Altering column size in SQL Server

How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5)

Read More
Need to list all triggers in SQL Server database with table name and table's schema

I need to list all triggers in SQL Server database with table name and table's schema. I'm almost there with this: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( …

Read More