C＃和SQL Server 2005(C# and SQL Server 2005)

 我有4张表，我从中获取记录。 前三个表需要内部连接和公共行，但是第四个表我需要左外连接，因为我必须保留前三个表中已经获取的行。 
 
 现在，问题是我希望左连接第四个表但它应该只选择具有date =当前日期的记录。 我在调用我的存储过程时从C＃传递当前日期。 但问题是SQL Server正在提供空记录。 
 
 这是查询:: 
 
alter procedure
  (@currentdate varchar(50))
  select distinct 
      table1.name, table2.class,table3.stream 
  from 
      table1
  inner join 
      table 2 on table1.id = table2.id 
  inner join 
      table3 on table3.id=table2.id   
  left outer join 
      table 4 on table 4.id = table3.id and table4.date = @currentdate
 
 我使用和左外连接因为我想要那样的记录，使用where子句过滤整个结果，只给我一条记录。 
 
 然后我也使用了存储过程中的两个日期，但没有正面响应。 
 
 从C＃我正在使用 
 
var date = datetime.now.toshortdate();
CallStoredProcedure(date)
 
 请尽快帮助我。 谢谢 

I have 4 tables from which I am fetching records. The first three tables required inner join with the common rows but with 4th table I need left outer join because I have to preserve the already fetched rows from first three tables. 
 
Now, problem is that I want left join with fourth table but it should only pick the records having date = current date. I am passing current date from C# while calling my stored procedure. But the thing is SQL Server is giving null records.
 
Here is the query::
 
alter procedure
  (@currentdate varchar(50))
  select distinct 
      table1.name, table2.class,table3.stream 
  from 
      table1
  inner join 
      table 2 on table1.id = table2.id 
  inner join 
      table3 on table3.id=table2.id   
  left outer join 
      table 4 on table 4.id = table3.id and table4.date = @currentdate
 
I used and with left outer join because I want records in that way where as using where clause filters the whole result and just give me one record.
 
Then also I used casting with both the dates in stored procedure but no positive response.
 
From C# I'm using 
 
var date = datetime.now.toshortdate();
CallStoredProcedure(date)
 
Please help me regarding this ASAP. Thank you 

原文：https://stackoverflow.com/questions/17257888