Обсуждение: Help w/procedures

Поиск
Список
Период
Сортировка

Help w/procedures

От
"CAMPZ"
Дата:
Hello,

I need help writing a procedure that will adding a group.

add_group:
- pass values for group name and 2 client ids and if valid (group name must
be not null and unique, client
ids must be not null and valid, client must not already belong to a group)
and add row to group table
- return value of team.id assigned, otherwise return a value of 0

Any help would be great thanks