°í¹Î°í¹Î ÇÏ´Ù°¡ µ¨¸¶´ç¿¡ Áú¹® ¿Ã·Áº¾´Ï´Ù.
c/s(µ¨ÆÄÀÌ-ms sql) ÇÁ·Î±×·¥¿¡¼ ÇÁ·Î±×·¥½ÇÇà½Ã »õ·Î µî·ÏµÈ ±ÛÀÌ ÀÖÀ» ¶§ TADOStoredProc¸¦ ÅëÇØ
¼¹öÀÇ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö¸¦ È£ÃâÇÏ¿© »õ·Î¿î ±ÛÀÌ ÀÖÀ» ¶§ ¸Þ¼¼Áö âÀ» ¶ç¿ì´Â ºÎºÐÀÌ ÀÖ½À´Ï´Ù.
¹®Á¦´Â °¡²û ´ÙÀ½°ú °°Àº ¿¡·¯°¡ ¹ß»ýÇÏ°ï ÇÕ´Ï´Ù.
" ÁÙ1: ÇÁ·Î½ÃÀú ¹øÈ£(0)°¡ À߸øµÇ¾ú´Ù. 1¿¡¼ 32767»çÀÌ¿©¾ß ÇÕ´Ï´Ù. "
¸Å¹ø ¹ß»ýÇϸé ÁÁÀºµ¥(?) °¡²û ¹ß»ýÇÕ´Ï´Ù.
ms sql¼¹ö¿¡ »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.
CREATE FUNCTION ufn_HW310_NEW(
@acadid char(3),
@receive_empno char(6))
RETURNS int
AS
BEGIN
DECLARE @cnt int;
SELECT @cnt = COUNT(*)
FROM HW310
WHERE ACADID=@acadid And RECEIVE_EMPNO=@receive_empno And READ_CHK='N';
RETURN @cnt;
END;
T-SQLÀÇ ¹®¹ý¿À·ù¶ó¸é ÇÔ¼ö ÀÚü°¡ ¸¸µé¾î ÁöÁö ¾Ê¾Ò°ÚÁÒ
°í¼ö´ÔÀÇ µµ¿òÀ» ¹Ù¶ø´Ï´Ù.