User profile for kkchan

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

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 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

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 can we help you today?

kkchan

Comments