1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
INSERT INTO PARTY (OID, PARTY_ID, DESCRIPTION, DESCRIPTION_PIN, NAME, FIRST_NAME, NAME_PIN, ORGANIZATION_NAME, ORGANIZATION_NAME_PIN,
POSTAL_ADDRESS, POSTAL_ADDRESS_L2, CITY, STATE, POSTAL_CODE, COUNTRY, COUNTRY_CODE, ADDRESS_PIN, EMAIL, EMAIL_PIN, PARTY_TYPE,
TREE_ELEMENT_TYPE, PARENT_ID, BUYER_ID, VENDOR_ID, PARTY_TEMPLATE_ID ) VALUES (@P0, @P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11,
@P12, @P13, @P14, @P15, @P16, @P17, @P18, @P19, @P20, @P21, @P22, @P23,
@P24)
declare @p2 int
set @p2=0
declare @p5 int
set @p5=0
exec sp_cursorexecute 76,@p2 output,16,8193,@p5
output,203,N'Vendor_1p0e@1l',NULL,1,N'Vendor_1p0e@1l',NULL,1,N'Vendor_1p0e@1l',1,NULL,NULL,N'Caen',NULL,N'14000',N'France',N'FR',1,NULL,1,1,0,NULL,N'Vendor_1p0e@1l',N'Vendor_1p0e@1l',NULL
select @p2, @p5
exec sp_cursorunprepare 1073741901
declare @p1 int
set @p1=0
declare @p2 int
set @p2=0
declare @p7 int
set @p7=0
exec sp_cursorprepexec @p1 output,@p2 output,N'@P0 nvarchar(4000),@P1 int,@P2 int,@P3 int,@P4 datetime,@P5 datetime,@P6 int,@P7 int,@P8 int,@P9
decimal(38,0),@P10 nvarchar(4000),@P11 nvarchar(4000),@P12 nvarchar(4000),@P13 decimal(38,0),@P14 nvarchar(4000)',N'INSERT INTO VENDOR_SETTINGS
(VENDOR_ID, DEFAULT_SCHEDULING_TYPE, DEFAULT_BILL_CYCLE_FREQUENCY, DEFAULT_EDIT_CYCLE_FREQUENCY, DEFAULT_BILL_CYCLE_DATE,
DEFAULT_EDIT_CYCLE_DATE, DEFAULT_EDIT_CYCLE_DATE_TYPE, DEFAULT_BILL_CYCLE_DATE_TYPE, DEFAULT_ACCOUNT_TYPE, DEFAULT_CREDIT, DEFAULT_CURRENCY,
DEFAULT_AML_FILENAMES, REFERENCE_FORMAT, BILL_THRESHOLD, BILL_THRESHOLD_CURRENCY) VALUES (@P0, @P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9,
@P10, @P11, @P12, @P13, @P14)
',4112,8193,@p7 output,N'Vendor_1p0e@1l',0,2,2,'juin 11 2128 10:53:20:000AM','juin 11 2128
10:53:20:000AM',0,0,-1,NULL,NULL,N'invoice.aml',N'{1,n,6}',NULL,NULL
select @p1, @p2, @p7
Lock:acquired
Error: 156, Severity: 15, State: 1
Syntaxe incorrecte vers le mot clé 'INSERT'.
Error: 16954, Severity: 10, State: 1
User Error Message Exécution directe de SQL. Pas de curseur. |
Partager