fakhravari
سه شنبه 22 اسفند 1391, 00:32 صبح
ممنون
query شما درست
ولی query مد نظر من توی پست اولم هست.
به کلمه with گیر میده .
USE [LogBOOKHOME]
GO
/****** Object: Table [dbo].[SyncChangesTable] Script Date: 03/12/2013 12:38:10 ق.ظ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SyncChangesTable](
[ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[TableName] [nvarchar](30) NOT NULL,
[RecordID] [nvarchar](30) NOT NULL,
[RecordValue] [nvarchar](20) NOT NULL,
[Operations] [nchar](1) NOT NULL,
[Flag] [tinyint] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SyncListTable] Script Date: 03/12/2013 12:38:10 ق.ظ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SyncListTable](
[TableName] [nvarchar](30) NOT NULL,
[Position] [tinyint] NOT NULL,
CONSTRAINT [PK_SyncListTable] PRIMARY KEY CLUSTERED
(
[TableName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[SyncChangesTable] ON
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(1 AS Numeric(18, 0)), N'B_Categories', N'CategoryID', N'7', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(2 AS Numeric(18, 0)), N'B_Categories', N'CategoryID', N'2', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(3 AS Numeric(18, 0)), N'B_Categories', N'CategoryID', N'2', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(4 AS Numeric(18, 0)), N'B_Forums', N'ForumID', N'34', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(5 AS Numeric(18, 0)), N'B_Forums', N'ForumID', N'35', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(6 AS Numeric(18, 0)), N'B_Categories', N'CategoryID', N'7', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(7 AS Numeric(18, 0)), N'B_Topics', N'TopicID', N'6', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(8 AS Numeric(18, 0)), N'B_Topics', N'TopicID', N'6', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(9 AS Numeric(18, 0)), N'B_Topics', N'TopicID', N'29', N'I', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(10 AS Numeric(18, 0)), N'B_Topics', N'TopicID', N'29', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(11 AS Numeric(18, 0)), N'B_Topics', N'TopicID', N'29', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(12 AS Numeric(18, 0)), N'Polls_Votes', N'VoteID', N'24', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(13 AS Numeric(18, 0)), N'Polls_Votes', N'VoteID', N'25', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(14 AS Numeric(18, 0)), N'Polls_Votes', N'VoteID', N'26', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(15 AS Numeric(18, 0)), N'Polls_Votes', N'VoteID', N'27', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(16 AS Numeric(18, 0)), N'Polls_Options', N'OptionID', N'5', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(17 AS Numeric(18, 0)), N'Polls_Questions', N'QuestionID', N'1', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(18 AS Numeric(18, 0)), N'Polls_Questions', N'QuestionID', N'3', N'D', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(19 AS Numeric(18, 0)), N'Polls_Questions', N'QuestionID', N'4', N'I', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(20 AS Numeric(18, 0)), N'Polls_Options', N'OptionID', N'3', N'U', 0)
GO
INSERT [dbo].[SyncChangesTable] ([ID], [TableName], [RecordID], [RecordValue], [Operations], [Flag]) VALUES (CAST(21 AS Numeric(18, 0)), N'Polls_Options', N'OptionID', N'4', N'U', 0)
GO
SET IDENTITY_INSERT [dbo].[SyncChangesTable] OFF
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'B_Categories', 1)
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'B_Forums', 2)
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'B_Topics', 3)
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'Link', 7)
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'Polls_Options', 5)
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'Polls_Questions', 4)
GO
INSERT [dbo].[SyncListTable] ([TableName], [Position]) VALUES (N'Polls_Votes', 6)
GO
vBulletin® v4.2.5, Copyright ©2000-1403, Jelsoft Enterprises Ltd.