求救！！！
我做一个项目的维护，客户要求在添加界面中多加一个县/区，要用到两张表，一个是地理位置表，里面有city_id,city_name,province_id,province_name
一个是school表，里面有两个外键：city_id,province_id
我现在要在添加学校的界面中实现添加“县和区“，用文本框实现，怎么做？
请大侠们赐教阿！小妹不胜感激！
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SaleTactic_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SaleTactic_Insert]
GO
CREATE PROCEDURE [SaleTactic_Insert]
@province varchar(50) , -----区
@city varcahr(50), ---县
@school varchar(50) -----学校
AS
IF NOT EXISTS(SELECT * FROM SaleTactic WHERE
province = @province and city = @city and school = @school )
BEGIN
---------这里写三个增加语句
RETURN 1
END
ELSE
RETURN 0
GO
---------------------仿造这格式写个存储过程就行了
