mysql_db_query for mssql in php

Question

What is mssql function that have similar with mysql_db_query()?

and what about mysql_insert_id()?

ops, sorry for not inform about language, it's php.

Hafizul Amri
– Hafizul Amri

2011-01-05 15:34:19 +00:00
Commented Jan 5, 2011 at 15:34 — Hafizul Amri
– Hafizul Amri, Commented Jan 5, 2011 at 15:34

fredley · Accepted Answer · 2011-01-05 16:12:50Z

1

Look at the PHP Mssql documentation. The functions you're looking for are mssql_query() and the following:

<?php 
function mssql_insert_id() { 
    $id = 0; 
    $res = mssql_query("SELECT @@identity AS id"); 
    if ($row = mysql_fetch_array($res, MYSQL_ASSOC)) { 
        $id = $row["id"]; 
    } 
    return $id; 
} 
?>

answered Jan 5, 2011 at 16:12

fredley

34.1k46 gold badges151 silver badges242 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hafizul Amri Over a year ago

For mysql, it has mysql_query and mysql_db_query, but for mssql only has mssql_query. mssql_query same with mysql_query but not with mysql_db_query.

fredley Over a year ago

@Hafizul mysql_db_query() is deprecated, all it does is (effectively) mysql_select_db() followed by mysql_query(). You can easily emulate this behaviour with mssql_select_db() and mssql_query().

Randy Minder · Accepted Answer · 2011-01-05 15:20:21Z

0

I think the closest you will come to this in T-SQL is the following:

Use <MyDatabase>
Exec ('Select <ColumnList> From <SomeTable>')

answered Jan 5, 2011 at 15:20

Randy Minder

48.8k55 gold badges221 silver badges373 bronze badges

Comments

Joseph Lust · Accepted Answer · 2011-01-05 15:51:59Z

0

In MSSQL, you can use the SCOPE_IDENTITY() function to get the last ID created by the given connection, in the same scope. Put them both together so you get the ID back just after row creation.

INSERT INTO myTable (field1,field2) VALUES(val1,val2); SELECT SCOPE_IDENTITY() AS myId;

Note, you could also use @@IDENTITY, but that returns the last ID created, regardless of scope, so if you inserted a new row, and a trigger/stored procedure fired and inserted something into another table, @@IDENTITY would return that ID.

answered Jan 5, 2011 at 15:51

Joseph Lust

20.1k8 gold badges91 silver badges86 bronze badges

Collectives™ on Stack Overflow

mysql_db_query for mssql in php

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related