SELECT * FROM Member
WHERE id not in(select uid from tiqu)
AND AgentCash > 3000
AND Password = '111111'
ORDER BY AgentCash desc

SELECT * FROM Member where UserName = '张亮星'

SELECT USERCODE FROM  Member
SELECT * FROM tiqu where uid = 17234

SELECT * FROM Member
WHERE NickName = '370444'
 ORDER BY NickName

SELECT * FROM Gee_Bonus
WHERE UID = 21871

INSERT Gee_Bonus(UID,UserID,did,sDate,eDate,b0,b1,b2,b3,b4,b5,b6,b8,b9,b11,b12,b10,b7,b13,b14) SELECT 33177,UserID,did,sDate,eDate,b0,b1,b2,b3,b4,b5,b6,b8,b9,b11,b12,b10,b7,b13,b14 FROM Gee_Bonus WHERE UID = 21871

SELECT * FROM Gee_Bonus

SELECT * FROM tiqu

where uid =  24822
ORDER BY RDT desc

UPDATE tiqu SET ispay = 0 WHERE id = (SELECT MAX(ID) FROM tiqu )


SELECT * FROM Member where NickName = '456342 '

update tiqu set uid = 17234,usname='胡志勇',bankname='建设银行',bankcd='6222802920781057123' WHERE id = (select max(id) from tiqu where uid = 24822 )

select 

UPDATE tiqu SET RDT = '2017/10/19 23:11:29' WHERE uid = 33177

SELECT * INTO #T FROM Gee_Bonus WHERE UID = 21871 

INSERT Member(UserID,uLevel,UserName,UserName2,repath,ReCount,AgentCash,ReID,ReName,Password,PassOpen,NickName,QQ,Email,BankName,BankCard,BankCity,UserCode,UserPost,RDT,TreePlace,FatherID,FatherName,ReTPlace,isPay,isLock,Shoplx,isAgent,AgentUse,lssq,zsq,AgentNO,ADT,SpareL,SpareR,M,L,R,BenQiL,BenQiR,isBoss,PDT,relevel,pLevel,pPath,b3t,shopid,ePoints,Points,b1,b2,b3,b4,b5,b6,b7,b8,b9,b12,b11,b10,b13,b0,b14,isoutA,lsk,wlf,IsD,GLF,isA,isB,isC,cpzj,[Sign],IDT,Buy,Stock) SELECT UserID,uLevel,UserName = '胡志勇',UserName2 = '胡志勇',repath,ReCount,AgentCash,ReID,ReName,Password,PassOpen,NickName = '370455',QQ,Email,BankName = '建设银行',BankCard = '6222021001136067201',BankCity = '上海市闵行支行',UserCode = '1',UserPost = '',RDT,TreePlace,FatherID,FatherName,ReTPlace,isPay,isLock,Shoplx,isAgent,AgentUse,lssq,zsq,AgentNO,ADT,SpareL,SpareR,M,L,R,BenQiL,BenQiR,isBoss,PDT,relevel,pLevel,pPath,b3t,shopid,ePoints,Points,b1,b2,b3,b4,b5,b6,b7,b8,b9,b12,b11,b10,b13,b0,b14,isoutA,lsk,wlf,IsD,GLF,isA,isB,isC,cpzj,[Sign],IDT,Buy,Stock FROM Member  where id = 21871

UPDATE Member SET BankName = '工商银行' WHERE NickName = '370455'

SELECT * FROM Member where reid = 6674
SELECT * FROM Member where id = 6675
SELECT * FROM Member where id = 6674
SELECT * FROM Member where BankCity  like '%上海%'


declare @sql varchar(1111) = ''
SELECT  @sql = @sql + ',' + name from syscolumns 
where id= OBJECT_ID('history')

print @sql 



UPDATE Member SET UserName = '李风晓' WHERE id = 21871
UPDATE Member SET UserName =  '胡志勇' WHERE NickName = '370455'

  SELECT * FROM Member where UserName like '%周%'
  and id not in(select uid from tiqu)
  and AgentCash > 0
  order by AgentCash desc
 
 SELECT * FROM  dbo.history where uid = 21871
 
 --ididid
 -- 33177
 
 INSERT history(uid,did,action1,PDT,epoints,content) SELECT 33177,did,action1,PDT,epoints,content from history where uid = 21871
 
 
 农业银行
 李风晓
 1
 
 
 ALTER TABLE member
 
 CREATE TABLE TMember(  FText VARCHAR(MAX))
 
 set  IDENTITY_INSERT member on