Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
PHP MSSQL - What Is a Result Set Object Returned by mssql_query()?
Submitted by: AdministratorA result set object is a logical representation of data rows returned by mssql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can use the following functions to retrieve detail information:
* mssql_free_result($res) - Closes this result set object.
* mssql_num_rows($res) - Returns the number rows in the result set.
* mssql_num_fields($res) - Returns the number fields in the result set.
* mssql_fetch_row($res) - Returns an array contains the next row indexed by field positions. The internal pointer is moved to the next row too.
Submitted by: Administrator
* mssql_free_result($res) - Closes this result set object.
* mssql_num_rows($res) - Returns the number rows in the result set.
* mssql_num_fields($res) - Returns the number fields in the result set.
* mssql_fetch_row($res) - Returns an array contains the next row indexed by field positions. The internal pointer is moved to the next row too.
Submitted by: Administrator
* mssql_fetch_array($res) - Returns an array contains the next row indexed by field positions and field names. The internal pointer is moved to the next row too.
* mssql_fetch_assoc($res) - Returns an array contains the next row indexed by field names. The internal pointer is moved to the next row too.
* mssql_fetch_object($res) - Returns an object representing the next row. The internal pointer is moved to the next row too.
* mssql_field_name($res, $i) - Returns the name of the field with the specified index.
* mssql_field_type($res, $i) - Returns the data type of the field with the specified index.
* mssql_field_len($res, $i) - Returns the data type size of the field with the specified index.
Submitted by: Administrator
* mssql_fetch_assoc($res) - Returns an array contains the next row indexed by field names. The internal pointer is moved to the next row too.
* mssql_fetch_object($res) - Returns an object representing the next row. The internal pointer is moved to the next row too.
* mssql_field_name($res, $i) - Returns the name of the field with the specified index.
* mssql_field_type($res, $i) - Returns the data type of the field with the specified index.
* mssql_field_len($res, $i) - Returns the data type size of the field with the specified index.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.