sqlserver 存储过程 简单问题

create procedure [dbo].[ReportMarkShow]
(
@BusinessId bigint,
@order nvarchar(20),
@UserId nvarchar(20)
)
as
BEGIN
declare @str varchar(5000)
declare @sql varchar(5000)

if @UserId = '0'
set @str = @str + ' and 1=1 '
else
set @str = @str + ' and Send_UserId = ' + convert(nvarchar,@UserId)

if @order = 'year'
set @str = @str + ' and Post_Date between Dateadd(yy,datediff(yy,0,getdate()),0) and Dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0)) '
else if @order = 'month'
set @str = @str + ' and Post_Date between Dateadd(mm,datediff(mm,0,getdate()),0) and Dateadd(ms,-3,dateadd(mm,datediff(m,0,getdate())+1,0)) '
else if @order = 'week'
set @str = @str + ' and Post_Date between Dateadd(wk,datediff(wk,0,getdate()),-1) and Dateadd(wk,datediff(wk,0,getdate()),6)'
else if @order = 

存储过程语法 sqlserver c# 存储过程调用错误 sqlserver 这段存储过程是什么意思？？？ sqlserver 急呀！！！怎么创建存储过程内？是sqlserver，阿 有关SQLSERVER数据库存储过程的编写问题！请教高手！ 在sqlserver中,存储过程proc,procedure什么区别 关于sqlserver中存储过程里面in关键字的使用 sqlserver 存储二叉树 怎样取SQLSERVER数据库表的PRIMARY KEY,有相关的存储过程吗? 通过asp直接调用sqlserver的存储过程和通过查询分析器得到的结果总有些小偏差是怎么回事?