SQL
anzhiqiang_touzi
软贱开发
展开
-
SQL语句实现[裴波那契数列]
CREATE FUNCTION FUN(@num int)returns intasbegin if(@num原创 2010-06-29 22:10:00 · 867 阅读 · 0 评论 -
SQL拆分函數
CREATE FUNCTION [DBO].[F_CHAR_SPLIT_TO_TABLE](@CHAR_LIST VARCHAR(MAX),@SIGN NVARCHAR(1))RETURNS @T_1 TABLE(ID INT,VALUE VARCHAR(MAX))AS BEGIN DECLARE @INTPOS INT, @SP_CHAR VARCHAR(MAX)原创 2011-11-02 13:50:29 · 688 阅读 · 0 评论 -
SQL将存储过程的结果插入到临时表
--存儲過程GOCREATE PROCEDURE [P_KBData]( @BeginTime datetime, @EndTime datetime)AS SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL SNAPSHOTselect DataName,DataID from P_KBData where D原创 2011-11-02 14:04:15 · 15007 阅读 · 0 评论 -
单元格内容超出宽度时隐藏多余部分
.textOverFlow { width:300px; overflow:hidden; text-overflow:ellipsis;/* (IE专用) */ white-space:nowrap; border:1px solid #ddd; }原创 2011-11-03 16:13:18 · 1228 阅读 · 0 评论 -
MSSQL杨辉三角
declare @SQL varchar(max) set @SQL=' SELECT'declare @Select varchar(max) set @Select=''declare @INSERT varchar(max) set @INSERT=''declare @n int set @n=10select @SQL=@SQL+C,@INSERT=原创 2012-06-01 18:01:42 · 552 阅读 · 0 评论 -
SQL2005以上版本的递归查询
with t as( select 1 as dt union all select dt+1 from t where dt+1) select dt from t原创 2012-05-17 14:16:59 · 430 阅读 · 0 评论 -
找出>=80%的前N项数据
--找出>=80%的前N项数据select 1 as Value,0.00 as P INTo #T INSERT INTo #T select 18,0.00 INSERT INTo #T select 14,0.00 INSERT INTo #T select 3,0.00 INSERT INTo #T select 13,0.00 INSERT INTo原创 2011-11-02 14:14:50 · 1477 阅读 · 0 评论