DECLARE @username varchar(100)
DECLARE myCusor CURSOR FOR
select username from username
OPEN myCusor
FETCH NEXT FROM myCusor INTO @username
    WHILE @@FETCH_STATUS = 0
  >查看详情
今天终于动了动触发器
回到家小写一个简单的
ALTER  TRIGGER reminder
ON userinfo
FOR INSERT
AS
declare @username varchar(10),@age int,@userid int
select @userid=userid,@age=age from userinfo
if(@age=23)
begi >查看详情
1、counter1.asp
<!--#include file="conn.asp"-->
<%
set rs=server.CreateObject("Adodb.recordset")
rs.open "Select *from story where id=1",cn,1,2
if session("counter")<>1 then
rs(" >查看详情
以前的分页程序,在翻页时,总是有点不便,比如一个地址有几个参数,那么在写分页时,要写上这些参数,现在用一个函数就可轻松搞定,才不用管它有多少个参数!
function.asp
<%
function HTMLEncode(fString)
if not isnull(fString) then
    fString = replace(fStri >查看详情
create database victor
use victor
create table mytable(id int primary key auto_increment,username char(10))
insert into mytable(username) values('victor'),('yansy'),('ysy'),( >查看详情