php 5.3.8版本,针对sql server 2008的注释编辑查看工具程序.docx

最近做一个项目, 用的是php 5.3.8, 数据库是sql server 2008,sql server的管理器,针对每个字段的东西很多,写个注释都要拉滚动条,每写一个得拉一下,非常麻烦.所以写了一个程序,通过网页列出表和字段,直接可以在网页上写注释,方便多了[php]view plaincopyprint??php/* Connect to the local server using Windows Authentication andspecify the AdventureWorks database as the database in use. */$serverName = (local); $connectionInfo = array( Database=zfdb2,uid=sa,pwd; $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn === false ) { echoCould not connect.\n; die( print_r( sqlsrv_errors(), true)); } if($_POST) { $sql=EXECUTE sp_updateextendedpropertyNMS_Description, N.$_POST[desc]., NSCHEMA, Ndbo, NTABLE, N.$_POST[table]., NCOLUMN, N.$_POST[col].; sqlsrv_query( $conn, $sql); $sql=EXECUTE sp_addextendedpropertyNMS_Description, N.$_POST[desc]., NSCHEMA, Ndbo, NTABLE, N.$_POST[table]., NCOLUMN, N.$_POST[col].; sqlsrv_query( $conn, $sql); die( print_r( sqlsrv_errors(), true)); } echoiframe name=p style=display:none/iframe; /* Set up and execute the query. */$tsql = select name from sysobjects where type=\U\; $stmt = sqlsrv_query( $conn, $tsql); if( $stmt === false) { echoError in query preparation/execution.\n; die( print_r( sqlsrv_errors(), true)); } /* Retrieve each row as an associative array and display the results.*/while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) { if($row[name]==dtproperties) continue; //echo $row[name].hr;$sql1=SELECT --TableName=CASE WHEN C.column_id=1 THEN O.name ELSE NEND, --TableDesc=CONVERT(VARCHAR, ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N)), 字段id=C.column_id, 字段名称=C.name, 是否主键=CONVERT(VARCHAR,ISNULL(IDX.PrimaryKey,N)), [IDENTITY]=CASE WHEN C.is_identity=1 THEN NYELSE NEND, --Computed=CASE WHEN C.is_computed=1 THEN NYELSE NEND, 类型=T.name, 长度=C.max_length, --Precision=C.precision, --Scale=C.scale, 是否可以为空=CASE WHEN C.is_nullable=1 THEN NYELSE NEND, 默认值=CONVERT(VARCHAR,ISNULL(D.definition,N)), 描述=CONVERT(VARCHAR,ISNULL(PFD.[value],N)) --,IndexName=CONVERT(VARCHAR,ISNULL(IDX.IndexName,N)), --IndexSort=CONVER