如何在SQL Server管理工作室中创建存储过程以显示数据? [英] How to create a stored procedure in SQL server management studio for displaying the data?
问题描述
大家好,
我只知道存储过程的基本概念,我还没有执行它。请帮忙。
我需要知道如何创建用于显示数据的存储过程。
例如:我们在一个表中有指定ID,在另一个表中有指定描述。我需要根据项目ID显示指定ID和指定描述。
我尝试过:
我试过如下
创建程序sp_procedure @projectid varchar(10)
As
开始
从
中选择deisgnationid
我很抱歉,因为我之前说过,我知道一些想法。在此之后我不知道需要写什么。
Hi All,
I know only the basic idea of stored procedure and I have not yet executed it. Please help on this.
I need to know how to create stored procedure for displaying the data.
Ex: We have designation id in one table and designation description in other table. I need to display both designation id and designation description based on the project ID.
What I have tried:
I tried as below
create procedure sp_procedure @projectid varchar(10)
As
Begin
Select deisgnationid from
Im sorry as I said earlier i know some idea. After this I dnt know what needs to written.
推荐答案
谷歌搜索是你的朋友:如何在SQL服务器管理中创建存储过程工作室用于显示数据? - Google搜索 [ ^ ]
这是在第一个搜索页面结果:如何在SQL Server Management Studio中编写存储过程 [ ^ ]
Google search is your friend: How to create a stored procedure in SQL server management studio for displaying the data? - Google Search[^]
This was on the first search page results: How to write a stored procedure in SQL Server Management Studio[^]
这篇关于如何在SQL Server管理工作室中创建存储过程以显示数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!