How to loop through result set objects using mssql_fetch_array()?
- 0 Answers
- 544 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is enhanced database mirroring in sql server 2008?
How to create indexed view?
What are the types of processing and explain each? : sql server analysis services, ssas
What are the difficulties faced in cube development? : sql server analysis services, ssas
Whether the updations made to the views reflect the original records in the table
what are different types of backups available in sql server? : Sql server database administration
What is a functions and types in sql server?
Difference between Function and Procedure-in general?
Does sql server 2000 full-text search support clustering?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
