/****** Script for SelectTopNRows command from SSMS UserID=3418 billyhero UserID=3390 divinity UserID=3392 guoguo ******/ --金币大于100W SELECT * FROM [QPTreasureDB].[dbo].[GameScoreInfo] where Score>1000000 or InsureScore>1000000
USE [QPTreasureDB]GO IF (object_id('TGR_GameScoreLocker_INSERT', 'tr') IS NOT NULL) DROP TRIGGER TGR_GameScoreLocker_INSERTGO CREATE TRIGGER TGR_GameScoreLocker_INSERT
create table #t(username nvarchar(50)) bulk insert #t from 'e:\名字列表.txt' with ( rowterminator='\n' ) SELECT id=identity(int,1,1), t.username INTO #regtemp11 FROM #t t ORDER BY id DESC