我不明白为什么表格中没有填写数据? [英] i didn't understand why data is not filled in that table?

问题描述

亲爱的所有人，
我在下面写了一个sp
当我在sql命令中成功运行时，但未在该表中填充数据.
任何机构都可以提供发现问题的线索.

Dear All,
I had written a sp given below
when i run in sql command successful,but data not filled in that table.
can any body provide the clue to find out problem.

create procedure sp_quatweek2
as begin
set nocount on 
declare @intcount int
declare @intwk_id int
set @intcount=1
set @intwk_id=1
declare @today date 
set @today=GETDATE() 
declare @fromdate date
declare @todate date
while(@intcount<=30)
begin
set @fromdate=DATEADD(day,0,@today)
set @todate=DATEADD(day,6,@today)
insert into quat_week(quatfrom)values(@today)
set @today=DATEADD(day,6,@today)
set @intwk_id=@intwk_id+1
set @intcount=@intcount+1
end
select * from quat_week with(nolock)
end

推荐答案

SQL Server Profiler是一个丰富的界面，可用于创建和管理跟踪以及分析并重播跟踪结果.您可以使用SQL内置工具找出实际结果.

如果您不熟悉SQL事件探查器，可以在

SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. You can use the SQL built in tool to find out the actual result.

If you are new to SQL profiler, you can refer the step by step tutorial at http://www.techrepublic.com/article/step-by-step-an-introduction-to-sql-server-profiler/5054787[^]

这篇关于我不明白为什么表格中没有填写数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！