You just need to add the tokens in the sql definition, DotNetNuke will replace them when it runs the sql e.g.

CREATE PROCEDURE {databaseOwner}{objectQualifier}DeletePortalInfo 
 @PortalID int

AS
 /* Delete all the Portal Modules */
 DELETE
 FROM {databaseOwner}{objectQualifier}Modules
 WHERE PortalId = @PortalID

 /* Delete Portal */
 DELETE
 FROM {databaseOwner}{objectQualifier}Portals
 WHERE  PortalId = @PortalID
   
GO

Public Overrides Sub DeletePortalInfo(ByVal PortalId As Integer)

SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner & ObjectQualifier & "DeletePortalInfo", PortalId)

End Sub