in reply to Re: What is similar in mssql to $dbh->listfields($tbl) in mysql
in thread What is similar in mssql to $dbh->listfields($tbl) in mysql
As a third alternative, you can also short-circuit the first query:
The parameter is the string name of the object, as in the longer query. Also, note that the object_id function has some shortcomings, but for the majority of situations the above will work just fine.select name from syscolumns where id = object_id(?)
|
---|
In Section
Seekers of Perl Wisdom