²½²½ÎªÓª .NETÈý²ã¼Ü¹¹½âÎö ¶þ¡¢Êý¾Ý¿âÉè¼Æ(2)
ÏÖ½¨Ò»¸ö¸ù¾Ý²¿ÃÅÃûÈ¡²¿ÃÅIDµÄ´æ´¢¹ý³Ì:
create PROCEDURE [dbo].[spGetdepartmenter] @departname nvarchar(50) AS BEGIN select * from department where departname = @departname ENDÔÙ½¨Á½¸ö¸ù¾ÝIDɾ³ýÊý¾ÝµÄ´æ´¢¹ý³Ì:
create PROCEDURE [dbo].[spDeletecustom] @id int AS BEGIN delete custom where id = @id ENDÊý¾Ý¿âÉè¼Æ¾Í½¨ºÃÁË,ÕâÖ»ÊÇÒ»¸ö¼òµ¥µÄʾÀý.»¶ÓÅÄש.
ÆÀÂÛ