PHP安装扩展连接sqlserver数据库

文章目录 收缩

安装php

安装php_pdo_sqlsrv扩展

PHP7及以上版本在此处下载:https://github.com/microsoft/msphpsql/releases
PHP5版本在此处下载:2021071409084286
根据php版本将php_pdo_sqlsrv_56_ts.dll放到php的ext目录,输入php -m,如果列表中显示了pdo_sqlsrv则说明扩展安装成功。

sqlserver驱动下载

https://www.microsoft.com/en-us/download/details.aspx?id=36434

其他

SQL Server全库搜索(在所有表中查找内容)

declare @Str nvarchar(max), @tableName varchar(50), @colName varchar(50), @rowCount int

select a.name tableName, b.name Colname, 0 as IsFound into #t1
from sysobjects a join syscolumns b on a.id=b.id join systypes c on b.xtype=c.xtype
where a.[type]='U' and c.name in ('varchar', 'nvarchar', 'char', 'nchar') --这里是设置字段的类型,以缩小范围

declare _c1 cursor for select Colname, tableName from #t1
open _c1
fetch next from _c1 into @colName, @tableName
while @@FETCH_STATUS=0 begin
--print @Str
select @Str='select @rowCount=count(1) from ['+@tableName+'] where ['+@colName+'] like ''%TotalDsc%''' --这里是要查找的内容
exec sp_executesql @Str, N'@rowCount int output', @rowCount output
if @rowCount>0 update #t1 set IsFound=1 where ColName=@colName and tableName=@tableName
fetch next from _c1 into @colName, @tableName
end
close _c1
deallocate _c1
select * from #t1 where IsFound=1
drop table #t1

来源:https://www.cnblogs.com/yechai/p/10997013.html

发表评论

邮箱地址不会被公开。 必填项已用*标注