Monday, 9 September 2013

Using system tables in VB.NET

Using system tables in VB.NET

I want to use the following SQL statements in a VB.NET app:
select * from information_schema.parameters
where specific_name='GetTaskEvents'
SELECT *
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_NAME= 'GetTaskEvents'
I spoke to the DBA about it today and he seemed unkeen, but did not give a
reason. Is it bad practice to do this?

No comments:

Post a Comment