å¨SQL Serveræ°æ®åºçç»´æ¤æè
Webå¼åä¸ï¼ææ¶éè¦å¨åå¨è¿ç¨æè
ä½ä¸çå
¶ä»æ°æ®åºæä½ä¸è°ç¨å
¶å®çåå¨è¿ç¨ï¼ä¸é¢ä»ç»å
¶è°ç¨çæ¹æ³
å¨SQL Serveræ°æ®åºçç»´æ¤æè
Webå¼åä¸ï¼ææ¶éè¦å¨åå¨è¿ç¨æè
ä½ä¸çå
¶ä»æ°æ®åºæä½ä¸è°ç¨å
¶å®çåå¨è¿ç¨ï¼ä¸é¢ä»ç»å
¶è°ç¨çæ¹æ³
ä¸ãSQL SERVERä¸è°ç¨ä¸å¸¦è¾åºåæ°çåå¨è¿ç¨
SQL 代ç
--åå¨è¿ç¨çå®ä¹
create procedure [sys].[sp_add_product]
(
@m_viewcount int = 0
,@m_hotcount int = 0
)
as
go
--åå¨è¿ç¨çè°ç¨
declare @m_viewcount int
declare @m_hotcount int
exec sp_add_product @m_viewcount,@m_hotcount
äºãSQL SERVERä¸è°ç¨å¸¦è¾åºåæ°çåå¨è¿ç¨
SQL 代ç
--å®ä¹åå¨è¿ç¨
create procedure [sys].[sp_add_product]
(
@m_viewcount int = 0
,@m_hotcount int output
)
--åå¨è¿ç¨çè°ç¨
declare @m_viewcount int =0
declare @m_hotcount int
exec dbo.sp_add_product @m_viewcount,@m_hotcount output
温馨提示:答案为网友推荐,仅供参考