多个检查SQL表 [英] Multiple Checking In SQL tables

问题描述

我有两张表格如下



1.ItemCode（string），ItemName（string），以及一些名为ItemMaster的字段。

2.ItemCode（string），BranchName（字符串），Qty（int）和....调用股票



我想从第二个表中检索数据如果分支和ItemName是正确的。



我没有传递ItemCode字段，我的搜索字段是ItemName。我怎么能做到这一点。请帮我找到解决方案



项目代码案例我写了storedproc

I have two tables as follows

1.ItemCode(string),ItemName(string),and some more field called ItemMaster.
2.ItemCode(string),BranchName(string),Qty(int) and .... called Stocks

I want to retrieve the data from second table if the Branch and "ItemName" are correct.

Am not passing "ItemCode" field my search field is ItemName. how I can achieve this. please help me to find solution

in itemcode case I write the storedproc

Alter Procedure ItemShow 
 @BranchName varchar(20) = NULL,
 @ItemCode varchar(20) = NULL
 As
 Begin
SELECT Distinct StockInBranches.ItemCode,StockInBranches.BranchName,StockInBranches.Price,StockInBranches.Qty
		
	FROM StockInBranches 
Inner Join ItemMaster On
   StockInBranches.ItemCode= @ItemCode
 WHERE StockInBranches.BranchName=@BranchName 
 End

怎么写itemname的情况？请检查。

how to write in itemname case? please check.

推荐答案

尝试

try

ELECT Distinct StockInBranches.ItemCode,StockInBranches.BranchName,StockInBranches.Price,StockInBranches.Qty

    FROM StockInBranches
Inner Join ItemMaster On
   StockInBranches.ItemCode= ItemMaster.ItemCode 
 WHERE StockInBranches.BranchName=@BranchName and (@ItemCode is null or StockInBranches.ItemCode = @ItemCode)

if你只需要传递BranchName然后

if you only need to pass BranchName only then

ELECT Distinct StockInBranches.ItemCode,StockInBranches.BranchName,StockInBranches.Price,StockInBranches.Qty

    FROM StockInBranches
Inner Join ItemMaster On
   StockInBranches.ItemCode= ItemMaster.ItemCode 
 WHERE StockInBranches.BranchName=@BranchName

这篇关于多个检查SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！