Database with a one-to-many situation query record __ Database

Situation One:

1. department Table one record

2. User Table 2 Records

Modify one field data for a Department table = one field data for a user table (2 different data in one field)

Result: The modification succeeds, ignores null, and takes the 1th from beginning to end in character order

Situation Two:

There is a user table, according to the query conditions of the result set has 2 rows

Another parameter to the stored procedure select @userid =userid from usertable

Result: The argument succeeds, ignores null, and takes the last 1 in character order

Know the result, wait for progress to parse.