嗨，如何创建存储过程，为骨小柱. [英] hi how to create stored procedure for peticular column.?

问题描述

我想创建存储过程，例如..
BID       TID
10.3.4   test1
10.3.4   test2
10.3.5   test1

现在，我想搜索创建存储过程，就像当我在页面上搜索TID时一样，认为m搜索test1可以，并且我希望tat记录仅用于垂直BID的TID.

谁能帮忙?

hi i want to create stored procedure for example..
BID         TID
10.3.4   test1
10.3.4   test2
10.3.5   test1

now i want to search create stored procedure like when i search in page for TID think m searching test1 ok and i want tat records only for perticular BID s TID.

can anyone help??

推荐答案

CREATE PROCEDURE FindTIDByBID 
 (
  @BID NVARCHAR(50)
 )
 AS
 Begin
   SELECT TID FROM table WHERE BID=@BID    
 End

CREATE PROCEDURE FindBIDByTID 
 (
  @TID NVARCHAR(50)
 )
 AS
 Begin
   SELECT BID FROM table1 WHERE TID=@TID    
 End

希望这会有所帮助，然后接受并投票回答
--Rahul D.

Hope this helps if yes then accept and vote the answer
--Rahul D.

如果TID是文本列，则存储过程几乎没有变化

If TID is a text column then there will be little change in store procedure

CREATE PROC SP_getTId
@TID nvarchar(1000)
AS
select BID from table1 where TID like @TID

这篇关于嗨，如何创建存储过程，为骨小柱.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！