嗨,如何创建存储过程,为骨小柱. [英] 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屋!
查看全文