编辑我解决了一半,我做了一个通过查询,所以现在我只需要:要实现到传递槽,不需要通过简单的查询。我的直通查询:SELECT COUNT( * ) FROM Hasznalat h WHERE l.lic_id = h.lic_id) AS felhasznaltFROM Licenszek l GROUP BY lic_kod, <em
Const sql_Emp As String = "Update TableA Set Contract = c.License_No, SEIN = convert(varchar, c.Lic_Exp_Date& "From Server.DB_B.dbo.TableB c Inner Join TableA b on " _
& "rtrim(ltrim(c.business_lic)) = rtrim(ltrim(cast(b.Account_Key as varchar(14
`old_course_id` INT(25), IN `new_course_id` BEGIN
DECLARE db_cursor CURSOR FOR SELECT lic.org_id, lic.course_id, lic.license_duration_typeid, lic.insert_date, lic.insert_by, lic.quantity FROM cdp_organization_licensesas lic</em
车辆=“汽车”;
‘'SELECT lic.licence_plate_num,lic.owner_name,lic.owner_address,lic.owner_tel_no,lic.owner_email,vio.violation_date,vio.violation_time,vio.vehicle_type,vio.violation_type从licence_plate_details右边加入violated_vehicles v