触发器,存储过程返回值

 static SqlConnection conn = new SqlConnection(@"database=ben;server=./SQLEXPRESS;integrated security=true");

       

 static void Main(string[] args)
        {
            useTrigger();
            useSp();
        }

        /// <summary>
        /// 使用触发器返回信息
        /// CREATE TRIGGER trg ON tmp
        /// FOR UPDATE
        /// AS
        /// BEGIN
        /// RAISERROR('错误！不允许更新',18,1)
        /// ROLLBACK
        /// END
        /// </summary>
        static void useTrigger()
        {           
            SqlCommand cmd = new SqlCommand(@"updatesql", conn);
            try
            {
                getCon();
                cmd.ExecuteNonQuery();
            }
            catch (SqlException e)
            {
                Consol