！郁闷不知道错在那里！~~~

2007-05-30 11:16:12 171 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

用App Inventor做个蓝牙温湿度计，手机自动连Arduino，5分钟搞定硬件数据上屏本文详细介绍了如何使用App Inventor和Arduino快速搭建一个蓝牙温湿度监测系统，实现手机自动连接并显示实时数据。通过图形化编程和硬件组装指南，零代码基础的用户也能在5分钟内完成硬件数据上屏，适用于智能家居、教学演示等多种场景。阅读详情

我写了一个存储过程创建没有问题
运行就有问题是什么原因啊
create procedure checkuser
@usertype int,
@userinfo varchar(200),
@userpwd varchar(200)
as
begin
declare @strSql NVARCHAR(500)
if(@usertype>0)
set @strSql='SELECT dbo.ayUser.UserID,dbo.ayUser.UserName,dbo.ayUser.UserEmail,dbo.ayUser.PassWordID, dbo.ayPassWord.ayPassWordID,dbo.ayPassWord.ayPassWord FROM dbo.ayPassWord INNER JOIN dbo.ayUser ON dbo.ayUser.PassWordID = dbo.ayPassWord.ayPassWordID where dbo.ayUser.username='+@userinfo+' and dbo.ayPassWord.ayPassWord='+@userpwd
else
set @strSql='SELECT dbo.ayUser.UserID,dbo.ayUser.UserName,dbo.ayUser.UserEmail,dbo.ayUser.PassWordID, dbo.ayPassWord.ayPassWordID,dbo.ayPassWord.ayPassWord FROM dbo.ayPassWord INNER JOIN dbo.ayUser ON dbo.ayUser.PassWordID = dbo.ayPassWord.ayPassWordID where dbo.ayUser.userEmail='+@userinfo+' and dbo.ayPassWord.ayPassWord='+@userpwd

EXECUTE sp_executesql @strSql
print @usertype
print @strSql
end

exec checkuser 1,'ddd','123456'

服务器: 消息 207，级别 16，状态 3，行 1
列名 'ddd' 无效。

给点帮助啊

...全文

手把手教你用LIO-SAM搞定激光雷达和IMU联合标定（附避坑指南）本文详细介绍了使用LIO-SAM进行激光雷达与IMU联合标定的全流程，包括标定原理、工具选型、硬件配置、数据采集、LI_calib标定步骤及LIO-SAM集成验证。特别提供了避坑指南和参数优化技巧，帮助开发者高效完成传感器标定，提升自动驾驶和机器人定位精度。阅读详情

hmilyfm

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

lwl0606 2007-05-30

打赏
举报

@userinfo , @userpwd 都是字段要比较的值，所以要加上引号，在表达式中 '' 代表 '
如果不加引号，它会认为是列，当列来处理，所以就会出现列名 'ddd' 无效。
用上面的试试

zsforever 2007-05-30

打赏
举报

--try
create procedure checkuser
@usertype int,
@userinfo varchar(200),
@userpwd varchar(200)
as
begin
declare @strSql NVARCHAR(500)
if(@usertype>0)
set @strSql='SELECT dbo.ayUser.UserID,dbo.ayUser.UserName,dbo.ayUser.UserEmail,dbo.ayUser.PassWordID, dbo.ayPassWord.ayPassWordID,dbo.ayPassWord.ayPassWord FROM dbo.ayPassWord INNER JOIN dbo.ayUser ON dbo.ayUser.PassWordID = dbo.ayPassWord.ayPassWordID where dbo.ayUser.username='''+@userinfo+''' and dbo.ayPassWord.ayPassWord='+@userpwd
else
set @strSql='SELECT dbo.ayUser.UserID,dbo.ayUser.UserName,dbo.ayUser.UserEmail,dbo.ayUser.PassWordID, dbo.ayPassWord.ayPassWordID,dbo.ayPassWord.ayPassWord FROM dbo.ayPassWord INNER JOIN dbo.ayUser ON dbo.ayUser.PassWordID = dbo.ayPassWord.ayPassWordID where dbo.ayUser.userEmail='''+@userinfo+''' and dbo.ayPassWord.ayPassWord='+@userpwd

EXECUTE sp_executesql @strSql
print @usertype
print @strSql
end

lwl0606 2007-05-30

打赏
举报

create procedure checkuser
@usertype int,
@userinfo varchar(200),
@userpwd varchar(200)
as
begin
declare @strSql NVARCHAR(500)
if(@usertype>0)
set @strSql='SELECT dbo.ayUser.UserID,dbo.ayUser.UserName,dbo.ayUser.UserEmail,dbo.ayUser.PassWordID, dbo.ayPassWord.ayPassWordID,dbo.ayPassWord.ayPassWord FROM dbo.ayPassWord INNER JOIN dbo.ayUser ON dbo.ayUser.PassWordID = dbo.ayPassWord.ayPassWordID where dbo.ayUser.username='''+@userinfo+''' and dbo.ayPassWord.ayPassWord='''+@userpwd+''''
else
set @strSql='SELECT dbo.ayUser.UserID,dbo.ayUser.UserName,dbo.ayUser.UserEmail,dbo.ayUser.PassWordID, dbo.ayPassWord.ayPassWordID,dbo.ayPassWord.ayPassWord FROM dbo.ayPassWord INNER JOIN dbo.ayUser ON dbo.ayUser.PassWordID = dbo.ayPassWord.ayPassWordID where dbo.ayUser.userEmail='''+@userinfo+''' and dbo.ayPassWord.ayPassWord='''+@userpwd+''''

EXECUTE sp_executesql @strSql
print @usertype
print @strSql
end

！~~~~~~~~郁闷不知道错在那里！~~~~~~~~~~~

相关推荐

！郁闷不知道错在那里！~~~