perl 连接SQL SERVER 数据库
发布时间:2020-12-15 23:50:03 所属栏目:大数据 来源:网络整理
导读:use DBI;$DSN = "driver={SQL Server};server=;database=;uid=sa;pwd="; # sql connection string$dbh = DBI - connect ("DBI:ODBC:$DSN") # set driveror die "could not connect to database";$sth = $dbh - prepare ("select * from SCHEMA_1.TB1") # ini
use DBI; $DSN = "driver={SQL Server};server=;database=;uid=sa;pwd="; # sql connection string $dbh = DBI -> connect ("DBI:ODBC:$DSN") # set driver or die "could not connect to database"; $sth = $dbh -> prepare ("select * from SCHEMA_1.TB1") # initialize command line or die "could not execute your sql command!"; $sth -> execute (); # execute while (@data = $sth -> fetchrow_array ()) { # get data print "id = $data[0] name = $data[1] n"; } $sth -> finish (); # finish this execution $dbh -> disconnect (); # disconnect from database (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |