我有以下脚本,但无法使用SQL Server迁移MySQL进行迁移。
CREATE PROCEDURE [usp_contacts_delete]
(_contactid int)
BEGIN
DELETE
FROM dbo.rivereast_contacts
WHERE contactid = _contactid
;
END
我可以使用哪种软件来迁移它,如果不能,我如何手动更改它以创建SQL Server的spx?
这应该不难:
CREATE PROCEDURE usp_contacts_delete (
@contactid int
) AS
BEGIN
DELETE FROM dbo.rivereast_contacts
WHERE contactid = @contactid;
END;