C# code:
INSERT INTO #Oldfencemytable (oldfence_name, animal_id) SELECT OldFence_Name, Animal_Id from TBL_AnimalMove WHERE (Animal_Id IN (SELECT animal_id from #mytable)) AND (OpTime IS NOT NULL) AND (OpTime IN (SELECT MIN(optime) from tbl_animalmove WHERE animal_id IN (SELECT animal_id from #myt ......
表是下面的格式
产品名称 描述编号 语言 产品描述
apple 1 E This is an apple.
apple 3 D Dies ist ein Apfel.
apple 1 F Il s'agit d'une pomme.
apple ......
id bh value time
K0011 01 25 2010-05-10 05:08:10
K0012 01 35 2010-05-10 05:10:10
K0013 01 35 2010-05-10 05:11:10
K0014 02 20 2010-05-10 05:08:11
K0015 02 50 2010-05-10 05:09:12
K0016 03 30 2010-05-10 05:08:10
K0017 03 25 2010-05-10 05:10 ......
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Test]
@sort_expression varchar(255)='Id',
@ascending varchar(20) = 'false'
AS
BEGIN
WITH
Found AS
(
select * from tablename
),
Rows AS
(
SELECT ROW_NUMBER() OVER ......
請求幫忙.
表中有gltr_eff_dt,跟gltr_amt 兩個字段,
gltr_eff_dt gltr_amt
2000/01/01 1
2000/01/02 3
2000/01/03 -1
2000/01/04 1
2000/01/05 8
2000/01/06 -5
.
.
.
.
2010/04/30 10
我想循環得到下表� ......
两个表 B 表的fd_person_id 与A表中的fd_id关联如下
A表
fd_id name
1 a
2 b
3 c
B表
fd_id fd_person_id
1 1
2 2
现在要判断 给定一个 A表的 NAME 判断这个name 是否存在与A表中又不存在于B表中
比如 给name 为c 返回的count 为1 给a b d e 等都返回0
谢谢 ......
最新文章 :