在 SQL 函数/问题中设置变量 [英] Setting variables in SQL functions/probs

问题描述

假设我有一个普通的 SQL 过程，它有几个参数.

Assume I have a normal SQL procedure which has a few arguments.

在调试期间，如果我可以为这些参数分配一些值，这样我就可以突出显示 proc 的主体并执行它(而不是手动用值替换变量.

During debugging it would be nice if i could assign some values to these arguments so that I can just highlight the body of the proc and execute it (as opposed to manually replace the variable with values.

有没有办法做到这一点?我试过了:

Is there any way to do this? I tried:

@Date1 datetime,
@Date2 datetime

SET @Date1 = '2012-03-23'

但它不喜欢它??

推荐答案

尝试声明@Date1 日期时间SET @Date1 = '2012-03-23'

您好像遗漏了声明语句.如果它不喜欢2012-03-23"部分，您可能必须将其投射.

Looks like you were missing the declare statement. If it doesn't like the '2012-03-23' part, you may have to cast it.

这篇关于在 SQL 函数/问题中设置变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！