SQLServer
ruiguang21
这个作者很懒,什么都没留下…
展开
-
sqlserver分页语句
select top 10* from (SELECT row_number() OVER(ORDER BY 关键词)AS RowNumber,* from TmpZTC_standard_promotion_plan_keyword_query) a WHERE RowNumber>(6-1)*10原创 2017-09-19 17:40:40 · 639 阅读 · 0 评论 -
SqlServer 创建变量表
DECLARE @liu TABLE ( seller_id BIGINT , thedate BIGINT , 访客数 BIGINT , 新访客数 BIGINT , 成交回头客数 BIGINT原创 2018-01-24 15:51:39 · 5287 阅读 · 0 评论 -
sqlserver 分页
--sqlserver 分页 select id,Brand,TradeNum_Month,TradeMun_LastMonth,TradeAmt_Month,TradeAmt_LastMonth,AvgPayment_Month,CollectNum_Month,AuctionNum,ShopNum,OperationDate from hyfx_BrandTradeDistribution原创 2018-01-24 09:31:38 · 159 阅读 · 0 评论 -
java 从数据库表反射出实体类,自动生成实体类
01.package com.db.gen.entity.tool; 02. 03. 04.import java.io.File; 05.import java.io.FileWriter; 06.import java.io.IOException; 07.import java.io.PrintWriter; 08.import java.sql.Connecti转载 2017-10-16 11:41:12 · 3719 阅读 · 0 评论 -
sqlserver 去除重复的数据
select * from lcsy_SettingPrivilege where SellerId=7 SELECT MAX(pid) as '最大标识ID',SellerId,PType,status,mtype,modName,picture,minipicture FROM lcsy_SettingPrivilege where SellerId=7 group by SellerI原创 2017-10-12 20:10:40 · 788 阅读 · 0 评论 -
存储过程 每15分钟分配一个区间 并相加
ALTER proc [dbo].[sp_hyfx_SoldOutDistributiones] (@thedate bigint) as begin -- create table #houres --(houres int ) --declare @i int --set @i=1 --while @i --begin --insert #houres valu原创 2017-10-19 16:58:57 · 366 阅读 · 0 评论 -
存储过程 每15分钟分配一个区间 并相加
ALTER proc [dbo].[sp_hyfx_SoldOutDistributiones] (@thedate bigint) as begin -- create table #houres --(houres int ) --declare @i int --set @i=1 --while @i --begin --insert #houres valu原创 2017-10-19 16:36:28 · 370 阅读 · 0 评论 -
存储过程排序+模糊查询
USE [YanShu_IndexDW] GO /****** Object: StoredProcedure [dbo].[SP_GetZTCStandardPromotionPlanKeyWord] Script Date: 2017/9/20 8:46:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO原创 2017-09-20 08:58:00 · 957 阅读 · 0 评论 -
模糊查询的存储过程
USE [YanShu_IndexDW] GO /****** Object: StoredProcedure [dbo].[SP_GetZTCStandardPromotionPlanKeyWord] Script Date: 2017/9/19 19:55:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO原创 2017-09-19 20:03:56 · 1145 阅读 · 0 评论 -
模糊查询存储过程
alter proc sp_person_sel_by_name @name varchar(50) AS begin DECLARE @SQL NVARCHAR(4000) , @SQLCount NVARCHAR(500) , @SelectColumns NVARCHAR(500) , @TmpStartRow NVARCHAR(原创 2017-09-19 19:27:22 · 1117 阅读 · 0 评论 -
如何编写一个带模糊查询的存储过程
CREATE proc sp_person_sel_by_name @name varchar(50) AS SELECT * FROM emp WHERE name like '%'+ @name +'%' GO原创 2017-09-19 18:13:24 · 1851 阅读 · 0 评论 -
sqlserver 经典sql语句case
select (alipay_order_num + succ_refund_order_num) ,case (alipay_order_num+succ_refund_order_num) when 0 then 1 else (alipay_order_num+succ_refund_order_num) end from ysf_ShopTrade nolock se原创 2018-01-17 10:47:06 · 771 阅读 · 0 评论