set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
Go
----截取字符串，并出去html
create FUNCTION [dbo].[CutString] (@str varchar(1000),@length int)
RETURNS varchar(1000) AS
BEGIN
declare @mainstr varchar(1000)
declare @substr varchar(1000)
if(@str is not null or @str!='')
begin
set @mainstr=dbo.regexReplace(@str,'<[\w\W]*?>','',1,1)
set @mainstr=dbo.regexReplace(@mainstr,'&[\w\W]*?;','',1,1)
if len(@mainstr)<=@length
set @substr=@mainstr
else
set @substr=substring(@mainstr,1,@length-2)+'..'
end
return @substr
END
一种：
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>兼容FireFox的当前时间的JS脚本</title>
</head>
<body>
<DIV id=time>当前时间
<SCRIPT>document.getElementById('time').innerHTML=new Date().toLo ......
