还有就是,我选中这个过程后点右键,选择运行选定内容也不报错啊,在数据库的存储过程项也会出现这个存储过程,但是我Modify它的时候,它的语法就变了: ALTER PROCEDURE checkName ( @userName varchar(50) ) AS select count(*) from UserInfo where U_name = @userName 这样对吗?
CREATE PROCEDURE checkName ( @userName varchar (50) ) AS begin Select count(*) from UserInfo where U_name = @userName endGo
SELECT U_name FROM UserInfo WHERE (U_name = 'nainse') 这条语句我单独执行就能查到数据
可能里面有非法字符,比如有char(13)而没有char(10) 新增查询,对着这里一个一个重新敲一次,或者直接复制代码转换后的代码,新学最好重敲一次:CREATE PROCEDURE checkName ( @userName varchar (50) ) AS Select count(*) from UserInfo where U_name = @userName Go
CREATE PROCEDURE insertUserInfo @userName varchar(50), @userPwd varchar(50) AS insert into UserInfo values(@userName,@userPwd) RETURN go 我执行这个过程的时候,数据是已经插如到数据库了,但是保存的时候还是说go列名无效!!!。
ALTER PROCEDURE checkName
(
@userName varchar(50)
)
AS
select count(*) from UserInfo where U_name = @userName
这样对吗?
(
@userName varchar (50)
)
AS
begin
Select count(*) from UserInfo where U_name = @userName
endGo
@RETURN_VALUE = 0
完成 [dbo].[checkName] 运行。
也没有报错,可是我用的参数值是数据表里已经存在的值啊
--(
@userName varchar (50)
--)
AS
Select count(*) from UserInfo where U_name = @userName Go
联机丛书:CREATE PROCEDURE
http://msdn2.microsoft.com/en-us/library/aa258259(SQL.80).aspx
CREATE PROCEDURE checkName
--(
@userName varchar (50)
--)
AS
begin
Select count(*) from UserInfo where U_name = @userName
endGo
FROM UserInfo
WHERE (U_name = 'nainse')
这条语句我单独执行就能查到数据
新增查询,对着这里一个一个重新敲一次,或者直接复制代码转换后的代码,新学最好重敲一次:CREATE PROCEDURE checkName
(
@userName varchar (50)
)
AS
Select count(*) from UserInfo where U_name = @userName
Go
@userName varchar(50),
@userPwd varchar(50)
AS
insert into UserInfo values(@userName,@userPwd)
RETURN
go
我执行这个过程的时候,数据是已经插如到数据库了,但是保存的时候还是说go列名无效!!!。
还有就是那个checkName的过程,我在vb.net里调用它的时候说是“无效操作,数据库连接关闭”