Hi gurus,

I am trying to create a stored proc, which accepts a database name as
parameter.
This is then supposed to query a table on a field
(db_version.current_version) in "that database", and check if the value in
that field is = '1.0.1.1'

If that matches , stored proc should return '1'. In all other cases, it
should return '0' (other cases could be , no table/field with name
db_version.current_version present in the specified database, table
present but field not present etc) .

I have tried using INFORMATION_SCHEMA.COLUMNS, but not getting a good
query to achieve the above result.

I appreciate any help given ! .. Thanks in advance.


regds,
Shrikant

Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

MS Sql Server LazyDBA home page