Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gamaz
Posting Yak Master
104 Posts |
 Posted - 2009-11-24 : 12:25:01
|
| Hi,I am debugging a stored procedure using visual studio 2005.This question is in reference to the following codelcreate proc testas@plant_para varchar(8) SET NOCOUNT ON CREATE TABLE #plan_hrs (plant varchar(8),machine varchar(10),plan_date datetime,plan_hrs int)INSERT INTO #plan_hrsselect * from mach_hrs where plant = @plant_para andplan_date >= cast(convert(varchar(8),getdate(),1) as datetime)--select * from #plan_hrs Now in my code the last statement is commented out. However is it possible to check the values of the temporary table plan_hrs by issuing a command in any of the debug windows.I would appreciate any help on this. Thanks. |
|
|
|
|
|
Debugging stored proc