User profile for kkchan

Failed to snapshot

Hi I am using ANTS memory profiler to profile my ASP.NET web app. However, I hit this error when I take snapshot. I am running under Windows 7 64 bits machine, however my web app pool is set "Enabl...

1 follower 1 comment 0 votes

Work using SDC UI but not command line

Hi, I have create SDC project and it works under SDC UI. However, I hit error if I run it using command line SQLDataCompare /project:c:\myproject.sdc /ignoremissing /scriptfile:c:\abc.sql Error: Co...

3 followers 4 comments 0 votes

Hi, I have tried to use dependencies tracker to my database. How could I know what cause my table "circular reference"? It shows my table used by another trigger/view/table. Thats it. But it doesn't show how which table cause the circular ref. Please advice. Thank you / comments

Hi, I have tried to use dependencies tracker to my database. How could I know what cause my table "circular reference"? It shows my table used by another trigger/view/table. Thats it. But it doesn'...

0 votes

Hi, Thank you for reply. I was thinking to use your approach. However, some of my tables required DML trigger to update another table such as update stock. Or, create another project for them as workaround? Any other ways? Thank you / comments

Hi, Thank you for reply. I was thinking to use your approach. However, some of my tables required DML trigger to update another table such as update stock. Or, create another project for them as wo...

0 votes

Hi, I posted the script generated as below. Master Table : Locations (LocationID - PK) Child Table: Terminals (LocationID = FK) As you can see, Terminal is "sync" before Locations. */ SET NUMERIC_ROUNDABORT OFF GO SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON GO -- Pointer used for text / image updates. This might not be needed, but is declared here just in case DECLARE @pv binary(16) BEGIN TRANSACTION -- Update 1 row in [dbo].[Terminals] UPDATE [dbo].[Terminals] SET [Descr]=N'Kuala Lumpur Culture Avenue', [LocationID]=2 WHERE [TerminalID]=1 -- Update 3 rows in [dbo].[Locations] UPDATE [dbo].[Locations] SET [Descr]=N'BOOKSTORES QUEENSBAY ', [CompanyID]=1 WHERE [LocationID]=5 UPDATE [dbo].[Locations] SET [Descr]=N'Bookstores Midvalley', [CompanyID]=1 WHERE [LocationID]=11 UPDATE [dbo].[Locations] SET [Descr]=N'BAC', [CompanyID]=1, [BusinessHourFrom]='18000101 09:10:00.000', [BusinessHourTo]='18000101 20:00:00.000' WHERE [LocationID]=12 -- Add 5 rows to [dbo].[Locations] SET IDENTITY_INSERT [dbo].[Locations] ON INSERT INTO [dbo].[Locations] ([LocationID], [Descr], [LocationTypeID], [CostCentreID], [CompanyID], [BusinessHourFrom], [BusinessHourTo], [DeviationMinute]) VALUES (2, N'KUALA LUMPUR CULTURE AVENUE ', 1, 0, 1, NULL, NULL, 0) INSERT INTO [dbo].[Locations] ([LocationID], [Descr], [LocationTypeID], [CostCentreID], [CompanyID], [BusinessHourFrom], [BusinessHourTo], [DeviationMinute]) VALUES (3, N'商品/業務銷售部 ', 1, 0, 1, NULL, NULL, 0) INSERT INTO [dbo].[Locations] ([LocationID], [Descr], [LocationTypeID], [CostCentreID], [CompanyID], [BusinessHourFrom], [BusinessHourTo], [DeviationMinute]) VALUES (4, N'TS WHAREHOUSE ', 1, 0, 1, NULL, NULL, 0) INSERT INTO [dbo].[Locations] ([LocationID], [Descr], [LocationTypeID], [CostCentreID], [CompanyID], [BusinessHourFrom], [BusinessHourTo], [DeviationMinute]) VALUES (6, N'BOOKSTORES KLANG ', 1, 0, 1, NULL, NULL, 0) INSERT INTO [dbo].[Locations] ([LocationID], [Descr], [LocationTypeID], [CostCentreID], [CompanyID], [BusinessHourFrom], [BusinessHourTo], [DeviationMinute]) VALUES (7, N'BOOKSTORES THE CURVE ', 1, 0, 1, NULL, NULL, 0) SET IDENTITY_INSERT [dbo].[Locations] OFF COMMIT TRANSACTION GO -- Reseed identity on [dbo].[Locations] DBCC CHECKIDENT('[dbo].[Locations]', RESEED, 12) GO Please advice. URGENT! / comments

Hi, I posted the script generated as below. Master Table : Locations (LocationID - PK) Child Table: Terminals (LocationID = FK) As you can see, Terminal is "sync" before Locations. */ SET NUMERIC_...

0 votes

INERT statement

Hi, SQL Prompt auto list out INSERT code template after I key in INSERT INTO mytable. Anyway to: 1. Allow me to select what fields to be inserted, or all? 2. Allow navigation to each value portion?...

1 follower 1 comment 0 votes

Parameter navigation

Hi, I tried SQL Prompt and found that it doesn't support "parameter navigation". For example, when I type "EXEC ", it prompted stored proc list for selection. After I select SP, it will parameter ...

1 follower 1 comment 0 votes

You could use a WHERE clause to reference the other table e.g. Code: WHERE LineItem.salesID in (select salesID from Sales where TerminalID = 45) Hi, Thank you for reply. As the value of 45 in the sql statement above might vary. Anyway I could replace it with "parameter" so that I could assign value to it during runtime? WHERE LineItem.salesID in (select salesID from Sales where TerminalID = @lnTerminalID) Thank you / comments

You could use a WHERE clause to reference the other table e.g. Code: WHERE LineItem.salesID in (select salesID from Sales where TerminalID = 45) Hi, Thank you for reply. As the value of 45 in ...

0 votes

How to control table sync order

Hi, I hit error when sync one of my table. It is caused by the Table PK used in another table. I am using trigger to control RI instead of foreign constraint. Due to this, I need to control the tab...

2 followers 4 comments 0 votes

Sync data programmatically

Hi, I have defined data sync using sql data compare and save it in project file. I would like to sync data programmatically, with all my configuration saved in project file with only few changes:- ...

1 follower 1 comment 0 votes

How can we help you today?

kkchan

Activity overview