in reply to Changing databases in MSSQL and fetching more than one row of results at a time

1. I don't know about SQL Server but most RDBMSs support dotted notation in the form catalog.database.table or database.table.

2. my $arrayref = $dbh->selectall_arrayref($sql,{},@binds);

  • Comment on Re: Changing databases in MSSQL and fetching more than one row of results at a time

In Section Seekers of Perl Wisdom