谁能帮我看看我的sql server的存储过程错在哪里..急..
CREATE PROCEDURE dbo.dt_login
@username varchar(100),
@result integer output
AS
begin
declare @sql_str varchar(1000)
if left(@username,len( @username )) in (select left(name,len( @username )) from sysobjects)
begin
set @result=0
end
else
begin
set @result=1
set @sql_str = 'CREATE TABLE ' + @username
exec(@sql_str)
end
end
GO