小弟的问题,哥哥们不要见笑,还请帮忙.

[8LY8Apollo]

有几个问题请教大家,请赐教,谢谢
1,安装了MSDE,怎么实现asp的SQL联接?
2,安装了MSDE,怎样修改SA的密码?
3,asp联接SQL数据库如果是选择windows验证代码该怎么写?
4,删除表的存储过程那里出错了?
create procedure p_del
@var_name varchar(30)
as
drop table @var_name
go
祝大家身体健康!

[erigido]

原来还有这么多人没休息呀.敬佩敬佩

[8LY8Apollo]

谢谢大力

[pengdali]

1、
<%
dim a,b,c
set a=server.createobject("adodb.connection")
a.open"driver={ sql server};server=msde实例名或机器名;uid=sa;pwd=;database=数据库名"
b="select * from xsjk"
set c=server.createobject("adodb.recordset")
c.open b,a
response.write c("user")&"<br>"
%>

2、
命令行下运行：
isql /S localhost /U sa /P /Q "exec sp_password null,'newpassword'"
参数值按你的情况改改

3、
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=sqldb;Data Source=localhost"
set rs1 = Server.CreateObject("ADODB.RecordSet")
sql="select * from ApplyCase"
rs1.Open sql,conn,1,1
if rs1.recordcount>0 then
...
else
...
end if

%>

4、
create procedure p_del
@var_name varchar(30)
as
exec('drop table '+@var_name)
go

[digitman]

up,注意休息
抵抗sars