SELECT t.* FROM  (select @lang:='de' p) as lang , getPreferredRoomType t Where _
  obj_Id_FK = 1

   SQL = "SELECT t.* FROM  (select @lang:='" & Lang & "' p) as lang ," & _
     "getPreferredRoomType t "
        SQL &= "Where obj_Id_FK = " & ObjectID
        mySQLCommand.CommandText = SQL
        myReader = mySQLCommand.ExecuteReader

 mySQLCommand.Parameters.AddWithValue("@Object_Id", item.Tag)
        mySQLCommand.Parameters("@Object_Id").Direction = _
          ParameterDirection.Input