正确的SQL Server SQL? [英] correct SQL for SQL Server ?
问题描述
你好,
我得到了这个问题,以确定SQL是否正确,以及它的真正作用。
是问题是否完整,或者我可以改进吗?
任何人都可以帮助我吗?
亲切的问候,Tony
< p style ="margin-bottom:0px; color:#222222; font-family:Arial,Helvetica,sans-serif; font-size:small">
INSERT   ; INTO [CTSourceDB_BE_Advodata] 。 [dbo] < wbr>。 [TimeSheetActivity]
&n bsp; ( [ID]
, [IDActivityType]
; , [Date]
, [描述]
, [IDCase]
, [IDOwner] )
SELECT distinct
ID = PrestatieID
, IDActivityType = 'Advodata'
, 日期 = Datum
, 描述 = ''
, IDCase = DosID
, IDOwner = cast ( NAAMIDUITVOERDER as varchar ) + '_ u'
FROM [Advodata_Source] 。 [dbo] < span style ="color:grey">。 [
inner join ( 选择 distinct left( id , charindex ( '_' , id ) - 1 ) as
ID 来自 [CTSourceDB_BE_Advodata] 。 [dbo]
查询未完成...
它应如下所示:
INSERT INTO [CTSour ceDB_BE_Advodata]。[dbo]。[TimeSheetActivity]
&NBSP; &NBSP; &NBSP; &NBSP; ([ID]
,[IDActivityType]
,[日期]
,[Description]
,[ IDCase]
,[IDOwner])
SELECT distinct
&NBSP; &NBSP; ID = PrestatieID
&NBSP; &NBSP; ,IDActivityType ='Advodata'
&NBSP; &NBSP; ,日期=基准
&NBSP; &NBSP; ,Description =''
&NBSP; &NBSP; ,IDCase = DosID
&NBSP; &NBSP; ,IDOwner = cast(NAAMIDUITVOERDER as varchar)+'_ u'
来自[Advodata_Source]。[dbo]。[Prestatie]
内部联接(选择不同的 左(id,charindex('_',id)-1)作为 ID 来自[CTSourceDB_BE_Advodata]。[dbo]。[身份]
  ; - )ON<<<条件加入表格>>
hello,
I got this question to find out if the SQL is correct, and what it really does.
Is the question complete, or can I improve it?
Can anybody help me ?
Kind regards, Tony
INSERT INTO [CTSourceDB_BE_Advodata].[dbo]
([ID]
,[IDActivityType]
,[Date]
,[Description]
,[IDCase]
,[IDOwner])
SELECT distinct
ID = PrestatieID
,IDActivityType = 'Advodata'
,Date = Datum
,Description = ''
,IDCase = DosID
,IDOwner = cast(NAAMIDUITVOERDER as varchar) + '_u'
FROM [Advodata_Source].[dbo].[
inner join (select distinct left(id, charindex('_', id)-1) as
ID from [CTSourceDB_BE_Advodata].[dbo]
The query is not complete...
It should look like something below:
INSERT INTO [CTSourceDB_BE_Advodata].[dbo].[TimeSheetActivity]
([ID]
,[IDActivityType]
,[Date]
,[Description]
,[IDCase]
,[IDOwner])
SELECT distinct
ID = PrestatieID
,IDActivityType = 'Advodata'
,Date = Datum
,Description = ''
,IDCase = DosID
,IDOwner = cast(NAAMIDUITVOERDER as varchar) + '_u'
FROM [Advodata_Source].[dbo].[Prestatie]
inner join (select distinct left(id, charindex('_', id)-1) as ID from [CTSourceDB_BE_Advodata].[dbo].[Identity]
--) A ON <<condition to join the tables>>
这篇关于正确的SQL Server SQL?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!