Shulou(Shulou.com)05/31 Report--

In this issue, Xiaobian will bring you about how to call stored procedures in SQL SERVER. The article is rich in content and analyzed and described from a professional perspective. After reading this article, I hope you can gain something.

SQL SERVER calls stored procedures without output parameters

SQL code

Create procedure [sys]. [sp_add_product] ( @m_viewcount int = 0 ,@m_hotcount int = 0)asgo --call to stored procedure declare @m_viewcount int declare @m_hotcount int exec sp_add_product @m_viewcount,@m_hotcount int exec

Second, SQL SERVER calls stored procedures with output parameters

SQL code

--Define stored procedure create procedure [sys]. [sp_add_product] ( @m_viewcount int = 0 ,@m_hotcount int output )--call to stored procedure declare @m_viewcount int =0declare @m_hotcount int exec dbo.sp_add_product @m_viewcount,@m_hotcount output

PS: Let me introduce you to SQL Server to find out which tables exist in a certain field.

If the naming of the database is more standardized, when we need to find out which tables exist in a certain field, it is very convenient to use the syscolumns system table to query the results in sql server.

The following sql code explains how sql server finds m_Id in which tables it exists

select tab.name table_name, col.name column_name from sysobjects tab left join syscolumns col on tab.id = col.id and tab.xtype ='U ' where col.name like '%m_Id%' order by 1,2 The above is how to call stored procedures in SQL SERVER shared by everyone. If you happen to have similar doubts, you may wish to refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.